Year to Date calculation query

[Anonymous]

Hello All,

I have a requirement to create a Year to date view of a ticket data coming in. It is a cumulative request and the ticket count should keep accumulating based on the tickets logged each month. If for a particular month there is no ticket details logged, the previous months count should be displayed as is. The counts should be reset at the beginning of every new year. I have created a chart based on the requirements, but I am facing an issue in the scenario wherein if for a particular month there are no tickets logged, no value is being displayed. Please refer to the chart below :

In the chart as you can see, there were no tickets logged for the dark blue section in the month of Dec'16, and the view showing up is incorrect. Similarly for Oct'17. The expression being used is as follows : Aggr(RangeSum(Above(Count(DISTINCT{<,[Nature Of Impact]={'Direct'},[Impact Type]={'High'},[Ticket Number]-={'0'}>}[Ticket Number]),0,RowNo())),Year,MonthofOccurence)

Could you please help out with this issue?

[Anil_Babu_Samineni]

Looks like you doesn't have Accumulated value. Can you attach the file to test

[sunny_talwar · Accepted solution]

How about this

Aggr(RangeSum(Above(Count(DISTINCT{<,[Nature Of Impact] = {'Direct'}, [Impact Type] = {'High'}, [Ticket Number] -= {'0'}>} [Ticket Number]) + Sum({1} 0), 0, RowNo())), Year, MonthofOccurence)

[Anonymous]

For your reference.

[sunny_talwar]

Does this look right?

[Anonymous]

Hi Sunny, this expression worked perfectly. Thanks a lot. Could you please explain this expression, as I couldn't figure out what was wrong ?

[sunny_talwar]

Just added a dummy value for all those MonthYears where they were null because of your set analysis.... the dummy value is Sum({1} 0) which allows you to accumulate as the value for the month year is now 0 instead of null.

[Anonymous]

Great, thanks a lot.