Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create a line chart with two measures that will show the current year and the previous year only. My only dimension is a field MonthYr. The current expression I am using to show all of the data is Count({<MissionStatusSK ={1347}>}Distinct InjurySK). I am needing to show only the injuries that have a status of 1347 for the current year and the previous year. I am having trouble with figuring out how to modify my expression to only include dates that fit the criteria. Any help would be greatly appreciated.
Thanks,
Phil Radovich
Have you created a master calendar?
If you have use set analysis to achive the same. e.g.
Year={"$(=Year(Max(OrderDate)))","$(=Year(Max(OrderDate))-1)"}
if you dont have a master calendar would recommend creating one