How to order a visual according to a rule?

Question & Answer
, , , ,
1

Hi,
I have a funnel chart and I would like to order the funnel according to my rule, but I can only group it by count or count distinct, I would like to be able to order it by numerical sequence, e.g.: 1, 2, 3, 4

I tried ifelse and switch, but it only groups by count.

Tks

2

Hi @July
How is your ifelse look like?
BR

3

ifelse(
{step} = ‘step1’, ‘1’,
{step} = ‘step2’, ‘2’,
{step} = ‘step3’, ‘3’,
{step} = ‘step4’, ‘4’,
null
)

4

Try

ifelse(
{step} = ‘step1’, 1,
{step} = ‘step2’, 2,
{step} = ‘step3’, 3,
{step} = ‘step4’, 4,
null
)

And set the aggregation to avg

1 Like
5

It works (it has no average, just count and distinct count), but my label is hidden, I need to use this calculated field only in orderning, but I need to show the label Step 1, Step 2, etc… and not 1, 2, 3, 4