-
Re: Sort by Calculated Expression?
Clever Anjos Jan 12, 2018 7:03 AM (in response to Peter Derrington)Maybe you can create a fake dimension with Valuelist() and have only one expression.
So you can use that expression under Sort tab
-
Re: Sort by Calculated Expression?
Peter Derrington Jan 12, 2018 7:18 AM (in response to Clever Anjos )Sorry, I'm not quite sure how I would do that.
Could you explain a little bit for me?
-
Re: Sort by Calculated Expression?
Clever Anjos Jan 12, 2018 7:24 AM (in response to Peter Derrington)Add ValueList('Exp1','Exp2') as dimension
Create one expression like
If(Valuelist('Exp1','Exp2') = 'Exp1',
Sum(Expression1),
If(Valuelist('Exp1','Exp2') = 'Exp2',
Sum(Expression2)
))
-
Re: Sort by Calculated Expression?
Peter Derrington Jan 12, 2018 9:16 AM (in response to Clever Anjos )Sorry, I'm obviously having a slow day.
I don't understand how that would work.
-
-
-
-
Re: Sort by Calculated Expression?
Sunny Talwar Jan 12, 2018 7:17 AM (in response to Peter Derrington)Would you be able to share a sample to try this out?
-
Re: Sort by Calculated Expression?
Peter Derrington Jan 12, 2018 7:43 AM (in response to Sunny Talwar )Attached is a small example of the data.
1st Graph:
Used Dimensions: 1stPlace
Expression 'General' - Count({<[1st Place Speciality]={'General'}>}([1stPlace]))
2nd Graph:
Used Dimensions: 2ndPlace
Expression 'General' - Count({<[2nd Place Speciality]={'General'}>}([2ndPlace]))
and then theres obviously lots of other expressions showing the other elements.
-
Example.xlsx 12.8 K
-
-