Calculating difference between two runningsum for max date only

Hi there,

Might be an easy one, but I’ve been sitting on this for hours…


Given this chart, which has 2 running sum calculations.
Let’s call them Target vs Actual.

How can I return one single number on a KPI card or in a table that only shows delta for the maximum day in the view?

My goal is to have a traffic light signal with Red-Amber-Green depending on how severe the delta is between the two on the last day.

Many thanks in advance!

Hi @Norbert ,

Can you share the calculated fields you are using? Or a sample solution in arena to understand the data granularity will also help.

In terms of execution, I can think of calculating the delta for each month and create another field to return the delta only for the last month. In that way we will not need to filter the data and the running sum stays unaffected.

Thanks,
Prantika

Hi @Norbert,
It’s been awhile since we last heard from you, are you still encountering issues or were you able to find a work around for your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @Norbert,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!