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

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

WildmoserGeorg — Fri, 27 Jan 2023 15:07:48 GMT

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

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

Michiel_QV_Fan — Fri, 27 Jan 2023 15:23:03 GMT

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.

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

WildmoserGeorg — Fri, 27 Jan 2023 16:09:25 GMT

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?

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

Michiel_QV_Fan — Tue, 31 Jan 2023 07:05:13 GMT

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.

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

vinieme12 — Tue, 31 Jan 2023 08:06:12 GMT

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)

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

WildmoserGeorg — Thu, 02 Feb 2023 07:42:28 GMT

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

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

WildmoserGeorg — Thu, 02 Feb 2023 07:48:09 GMT

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

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

WildmoserGeorg — Thu, 02 Feb 2023 08:48:49 GMT

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