Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
WildmoserGeorg
Contributor III
Contributor III

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

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:

WildmoserGeorg_0-1674831002143.png

View with filter may on complaint (unfortunately):

WildmoserGeorg_1-1674831226540.png

What I would like to see if I filter may in the complaint (here with an unwanted intermediate step - filtering by item):

WildmoserGeorg_2-1674831486798.png

 

Thanks 4 help. 🙂

 

Labels (1)
1 Solution

Accepted Solutions
WildmoserGeorg
Contributor III
Contributor III
Author

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

WildmoserGeorg_0-1675327722162.png

 

View solution in original post

7 Replies
Michiel_QV_Fan
Specialist
Specialist

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
Contributor III
Contributor III
Author

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
Specialist
Specialist

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
Champion III
Champion III

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)

 

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
WildmoserGeorg
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

WildmoserGeorg_0-1675327722162.png