Customer experience | Sales, Customer Insights,...

Sorting of Funnel chart on the business process for a dashboard

(0) Share

Report

Posted on by Community Member

I have an existing funnel chart on a dashboard that is sorting the stages of the business process in the wrong order. How do I define the order the stages should be in?

I have the same question (0)

All responses (2)

Answers (0)

lefmapeach 15 on at

Like (0)

Report

A funnel chart will automatically order the stages with the one having the more $ or # on top, then funneling down to the one that has less. Maybe the funnel chart is not the best display for what you're trying to achieve.

Was this reply helpful? Yes No
Suggested answer

LuHao 40,892 on at

Like (1)

Report

Hi Sandi,

We can manually add the xml code to sort it in ascending alphabetical order by stage name.

For example, the chart's category is ‘status’.

The steps are 1) export the chart, 2) add the sort code line, and 3) import the chart.

Add <order alias="stepname" ascending="true" /> between <entity name=...> and </entity>.

It will be sorted in ascending alphabetical order by category label. (L > O > W)

If your stage is not in alphabetical order by name, then I recommend that you add a first letter for the stage name, such as 1-Qualify, 2-Develop, so that the stages can be arranged in the order you want.

Was this reply helpful? Yes No