Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I ahve a very difficult logic to implement in a line chart . please look into my beow explanantion
Difficult logic:
I need to show a line chart by month .
I have month as dimension and in expression I am using this logic "
Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,rowno()))
For the above reverse cummulative expression works fine as shown in the figure below . Now i want to add the total count of id's to the max month . how can i achive this .
If i get the total count for the year added to the Oct month then it will cummulate .
Can any one please help me on this .
Thanks in Advance
HI @smilingjohn
Try like below
If(MonthYear = Max(Total MonthYear), Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), count({<Status={'Closed'},Dept={'Incometax'}>}ID)),
Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), Count({<MonthYear={'$(=Max(MonthYear))'},Status={'Closed'},Dept={'Incometax'}>}ID))+Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,NoOfRows())) )
Hi Community any help on this ?
Hi community
Is my requirements possible ??
Hi @smilingjohn ,
Try like below
If(MonthYear = Max(Total MonthYear), count({<Status={'Closed'},Dept={'Incometax'}>}Total ID),
Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,rowno())) )
Hope it helps
Currently this is how my data looks .as shown in the figure . the total ID's are 11 , now this 11 Id's should get added to Sept which should be like 11+4=15 and this 15 should get added to Apr=2+15 and so on till Jan2018 .
HI @smilingjohn
Try like below
If(MonthYear = Max(Total MonthYear), Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), count({<Status={'Closed'},Dept={'Incometax'}>}ID)),
Rangesum(count({<Status={'Closed'},Dept={'Incometax'}>}Total ID), Count({<MonthYear={'$(=Max(MonthYear))'},Status={'Closed'},Dept={'Incometax'}>}ID))+Rangesum(below(count({<Status={'Closed'},Dept={'Incometax'}>}ID),0,NoOfRows())) )