How to do it...

  1. Go to the App overview window and open a new sheet.
  2. Enter the Edit mode by clicking on .
  3. Create a Table chart.
  4. Add a new dimension, and click on the fx button to create it as an expression.
  1. Insert the following expression:
=if(Value < 10, dual('less than 10',1),
if(Value < 30, dual('<30',2),
if(Value < 60, dual('<60',3),
dual('above 60',4))))
  1. Type Range as a label for the dimension.
  2. Add Count(Value) as a measure.
  3. The result would be as follows:
  1. Change the sorting order of Range dimensions from automatic to Custom, and set sort to numerically.
  2. The result would be as follows:
  1. As we can see, the sort order is correct now.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset