6 Replies Latest reply: Jan 12, 2018 9:16 AM by Peter Derrington

Sort by Calculated Expression?

Peter Derrington Jan 12, 2018 6:58 AM

Hi,

Hoping for some guidance.....

I have a set of bar charts that each show a stacked bar that contains a set of defined expressions.

eg: Count({<[4th Place]={'All Things'}>}([4thThere]))

What I would like to happen is for when I select a defined element (eg Month) that it alters the order of the chart so that the largest numbered section is at the bottom. At the moment it retains everything in the order that is shown in the 'Expressions' Tab.

Any ideas?

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
Like Show 0 Likes (0)

Actions
- 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?
  
  Like Show 0 Likes (0)
  
  Actions
  - 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)
    ))
    
    Like Show 1 Like (1)
    
    Actions
    - 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.
      
      Like Show 0 Likes (0)
      
      Actions
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?
Like Show 0 Likes (0)

Actions
- 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
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post