Canonical Dates - How to filter for "complaint date" and also get the months of the "order dates" etc displayed in a bar chart??

[WildmoserGeorg]

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. 🙂

[Michiel_QV_Fan]

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.

[WildmoserGeorg]

Thanks for the quick reply. The complaint date indirectly filters the items. Is it possible to ignore the filtering of the complaint date on the time series using Set Analysis, so that only the indirect filtering of the item affects the bar chart? If so, what should the formula be?

[Michiel_QV_Fan]

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.

[vinieme12]

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)

[WildmoserGeorg]

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. 😄

[WildmoserGeorg]

You are right. Only I had already considered these points. But your answer and the hint from michielvandegoo put me on the right track. 😄

[WildmoserGeorg · Accepted solution]

i had to clean up the data model. Now it works.