Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to display orders, deliveries and complaints in a bar chart. With instructions from rwunderlich and hic I built a canonical calendar. I get the different dates in a time series. See attachement.
My problem is that the display of the time series is restricted as soon as I select an order date, complaint date or delivery date.
For example, I would like to select the month of may in the complaint month and get back the indication in the bar chart that the associated order was made in march, delivery was in april and the complaint was made in may. I would like to filter using the complaint date without the intermediate step of the item number.
Only the month of may is currently displayed. What am I doing wrong or do I still have to adjust?
View without filter:
View with filter may on complaint (unfortunately):
What I would like to see if I filter may in the complaint (here with an unwanted intermediate step - filtering by item):
Thanks 4 help. 🙂
If you selected the canonical date in may all data is filtered to may, regardless of the other dates.
Yes, you should go with item number to get the events in different months.
To ignore a selection in set analysis just add the field name without a parameter. Like this:
Sum({<Year = {'2022'}, Month>}Sales)
In this way Month selections are ignored.
Well, you should only be filtering on the Canonical YEar,Month, Date fields
thats the point of having Canonical Calendar because May of CanonicalMonth is associated to All DateTypes
Whereas May of Xyzfield is only associated to that Data
Just do below changes
1) Simply use Canonical Calendar fields for filtering
2) and as a rule you must specify Which Datetype you are calculating on
your measures should specify the Datetype as below
Measure1: count({<Datetype={'leifrung'}>} Sales)
Measure2: count({<Datetype={'beanstandung'}>} Sales)
Measure3: count({<Datetype={'bestelung'}>} Sales)
Thought to ignore an entire table. Kind of:
sum({<$<DateType={'Bestellung'}>} {<$(=concat({1< $Table = {'BeanstandungsDatumCalendar'}>} $Field, ' ,'))>} BestellMenge)
But your answer and the hint from Vinieme12 put me on the right track. 😄
You are right. Only I had already considered these points. But your answer and the hint from michielvandegoo put me on the right track. 😄
i had to clean up the data model. Now it works.