Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
Thanks for looking into this.
Request you to please help me in refining the existing expression by adding the rangesum in it as mentioned in following screenshot-
Count(TICKET_ID) / COUNT ( TOTAL <CLOSED_MONTH_CALC> TICKET_ID)
above formula calculates the % per CLOSED_MONTH_CALC
we need to introduce running sum as mentioned below per CLOSED_MONTH_CALC -
Thanks for looking into this..
Best Regards,
Rahul
Try this
RangeSum(Before(Count(TICKET_ID) / COUNT ( TOTAL <CLOSED_MONTH_CALC> TICKET_ID), 0, ColumnNo()))
Try this
RangeSum(Before(Count(TICKET_ID) / COUNT ( TOTAL <CLOSED_MONTH_CALC> TICKET_ID), 0, ColumnNo()))
Thank you Sunny.. 🙂
Hi Sunny,
Thanks for the help. 🙂 & sorry for the continuous queries on this subject.
The above solution is working fine however there is another requirement.. I have added another row named as 'CLOSED_DATE' beneath CLOSED_MONTH_CALC which has dates in it(falling under month of CLOSED_MONTH_CALC ).
i want to calculate the runningsum for 'CLOSED_DATE' as well. Please recommend how it can be achieved :)-
* do i need to add something to below formula - ?
RangeSum(Before(Count(TICKET_ID) / COUNT ( TOTAL TICKET_ID), 0, ColumnNo()))
* Or need to add another measure?
Thanks again
Best Regards,
Rahul
I am not sure I follow the req completely... do you mind sharing an example to show what is going on?
No worries. it worked out.. thanks for replying.
Have a good day.
Awesome!!