How to handle multiple dates

[rupaliqlik]

Hi,

This is interview scenario.

I Have 3 charts and 3 diffrent date field.
1st chart is calculated on Production Date.
2nd chart is calculated on Despatch Date.
3rd chart is calculated on Supplier Date.
I have MasterCalendar from which Year and Month came.Master calendar is island in datamodel not connected with model.
When I select Year and month all the 3 charts should calculated correctly.

[MayilVahanan]

HI Rupaliqlik,

In that case, you can use P() function in set analysis like below

Count({<ProductionDate = p(Mastercalendar.Date)>} Distinct Products)

But it impacts performance, to avoid this, need to change the data model to link the 3 fields with master calendar.