Funnel chart

[liucia_liucia]

Hey!

I want to create funnel char and do my own numeration of 'company.lead status' (for example the first one would be 'in_progress' the second "New"):

 

Is it possible to do this numeration in the funnel chart?

[MatheusC · Accepted solution]

You can make a master dimension with the dual() and Match() functions to create your list.

And have it sorted by the master dimension you created.

=dual("company.lead status",
              Match("company.lead status",'in_progress','New','  ',....))


- Regards, Matheus

[liucia_liucia]

I write this code: dual([Company.Lead Status], Match([Company.Lead Status],'UNQUALIFIED','IN_PROGRESS','NEW', 'OPEN_DEAL', 'UNQUALIFIED', 'Competitors', 'OPEN', 'BAD_TIMING')), but sadly it does not work.

[MatheusC · Accepted solution]

In this case, he is prioritizing the sorting by Measure 1, try changing the position by moving Dimension 2 – Company.Lead Status up in the sorting and ascending.

2
1

- Health

[qv_testing]

You can go with below one

Create dummy table for sorting like (If you have more status values you can include in inline table)

Load * inline [
lead status, SortPosition
in_progress, 1
New, 2
];

Lead_Status should be associate with Main table.

Then use the field name SortPosition to sort by expression.