I would like to create a create a “backlog KPI”.
(per week, calculate the amount of cases closed this week minus the amount of cases created this week)
Creation date & close date are stored in 2 different fields of 2 different tables. (cases creation & closure are not actually part of the process in itself).
At the moment, I can create 2 column charts:
- 1 chart with dimension = creation week and KPI = Count of cases
- 1 chart with dimension = closure week and KPI = Count of cases
I fail to merge this into 1 single chart, with dimension = fixed weeks and KPI = (Count of cases where closure date matches with the fixed week - Count of cases where creation date matches with the fixed week)
Is there a way to do this, in the Analysis EDIT mode or through data-model configuration in HANA?
I hope this was clear enough for you to be able to support me
Thank you for your help,