Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.