Use same expressions for different data origins (fields)

[magellan]

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?

[steeefan · Accepted solution]

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.

[magellan]

Thank you very much. This worked!