Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a master calendar with fields such as Year_A, Month_A, Day_A and Date_A.
The facts tables use start_date.
Normally I can do easy counts such as "Count({<start_date=P(Date_A)>}event_code)", but what about when it comes to a master dimension that I want to use to drill down in a bar chart?
I used to have a master dimension with Year, Month and Day. Now that I'm using the master calendar I changed it to Year_A, Month_A, Day_A. How do I get it linked to start_date so it counts events from the facts table?
I'm using "Count({<start_date=P(Date_A)>}event_code)" but it does not seem to be right.
Thanks
Hi, I'm having a look at this issue again. I now have a master calendar linked to start_date as @dplr-rn had mentioned.
I'm configuring the drill-down as Year, Month, Day from my master calendar.
In the bar chart, I still want to show days where data = 0 for them, so I'm counting like this in the measure:
Count(code) + 0 * Count({1}code)
Now my problem is that all months are showing up to 31 days. How can I make it so August shows 31 days, September 30, etc.?
Thanks