CASE count in relaton to selected Business Case

Technical Implementation Analysis
#1

Hello dear community,

I`m sure you kann help me.
I’ve have an Olap table, in the dimension is the table, which shows certain change activities.
As KPI I want to calculat a relation of case count(of change actvities)/case count (dependant of different business cases)
In the denominator should be a variable, that shows the case count of different business cases.

Thank you, I hope you understood me

#2

Hi @Micha.B,

thanks for reaching out and welcome to our community!

Could you please provide the PQL statements that you have started with. That would make easier to understand your use case for everyone.

Best,

Justin