CLASS function output adjust

[#1]

Hello,

The output of the Class function on my dashboard is like:

0 <= dias < 3

3 <= dias < 6

6 <= dias < 9

9 <= dias < 12

12 <= dias < 15

15 <= dias < 18

But i want the result like '0 ~ 3 dias'. I´ve tried to use the replace function, but the expression lost the sort order, anyone have any idea how could i replace this without loose the sort order?

Thanks!

[alexandros17]

I've not understood, please provide your example

[marcus_sommer]

Change the sorting on expression with these class-function without replace().

- Marcus

[#4]

An example was attached! Use the slider to view the sort order in the legend ! Alessandro Saccone

[#5]

I've not understood!

[jerem1234 · Accepted solution]

Here are two ways:

1. Keep dimension the same, and use expression in sorting:

=only(CLASS(dias_aberto0, $(vStep)))

2. Use the dimension:

=dual(REPLACE(CLASS(dias_aberto0, $(vStep)), '<= x <','~') & ' dias', CLASS(dias_aberto0, $(vStep)))

and use sorting numeric - ascending

Please find attached.

Hope this helps!

[Anonymous]

Attached is the correct solution.

=DUAL(REPLACE(CLASS(dias_aberto0, $(vStep)), '<= x <','~')& ' dias',CLASS(dias_aberto0, $(vStep)))

sort by number then ascending

[MK_QSL]

Try like below...

=DUAL(REPLACE(CLASS(dias_aberto0, $(vStep)), '<= x <','~') & ' dias',CLASS(dias_aberto0, $(vStep)))

Once you use Replace function, the output of Class function convert from Number Format to Text Format.

[#9]

Thank you so much!

[#10]

Thanks, i'll remember that!