Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have several expressions which calculate KPIs, but have more than one data origins containing columns.
Let's say in this example its SH: TicketVolume and ST: TicketVolume
Now the expressions work when I directly use the fields of the origins like this:
sum(aggr(count(if([SH: Ticket Volume (Created)] > 1 AND AE <> isnull,[SH: Ticket Volume (Created)])),[SH: Ticket Volume (Created)]))
What I'm trying to achieve is that this expression can be used with ST:TicketVolume as well. So that I don't have to create the same expression for each data origin. I tried it with variables but it seems that these won't be recognized as the field after passing them through.
What would be the best way to achieve this?
Modify your expression like this:
sum(aggr(count(if([S$(vHT): Ticket Volume (Created)] > 1 AND AE <> isnull,[S$(vHT): Ticket Volume (Created)])),[S$(vHT): Ticket Volume (Created)]))
Create the variable vHT and define it as either 'H' or 'T'. This should give you the desired results.
Modify your expression like this:
sum(aggr(count(if([S$(vHT): Ticket Volume (Created)] > 1 AND AE <> isnull,[S$(vHT): Ticket Volume (Created)])),[S$(vHT): Ticket Volume (Created)]))
Create the variable vHT and define it as either 'H' or 'T'. This should give you the desired results.
Thank you very much. This worked!