Count Year by year

philip_radovich — Mon, 05 Nov 2018 19:03:23 GMT

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

Re: Count Year by year

dplr-rn — Mon, 05 Nov 2018 20:20:19 GMT

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

topic Count Year by year in App Development

Count Year by year

Re: Count Year by year