Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have three expressions. Is it possible to combine three expressions and form it as a single dimension to use that in a bar chart?
What type of expressions? I would be a concatenation of all three expressions?
Exp1 & Exp2 & Exp3 or Exp1 & ' - ' & ....
These are those expressions I'm using,
1. Count(DISTINCT{<Customer= E(Customer),comparison={'true'},BusFields=P(BusFields),withcond4=P(withcond4),withcond3=E(withcond3),withcond2=E(withcond2),withcond1=E(withcond1),withcond=E(withcond)>}withcond4)
2. Count(DISTINCT{<Customer= E(Customer),comparison={'true'},BusFields=P(BusFields),withcond1=P(withcond1),withcond=E(withcond)>}withcond1)+Count(DISTINCT{<Customer= E(Customer),withcond2=P(withcond2),withcond=E(withcond)>}withcond2)
3. Count(DISTINCT{<Customer= E(Customer),comparison={'true'},BusFields=P(BusFields),withcond3=P(withcond3),withcond2=E(withcond2),withcond1=E(withcond1),withcond=E(withcond)>}withcond3)
How can I combine these three expressions in the script and make it as a single dimension?
would should be the outcome?
Do you need a single number or three different numbers? 1 (the sum of the three expressions) or 1 - 2 - 3 (a combination of the three expresions)