Forum Discussion
Sorting a funnel chart
Hi,
I am trying to sort a funnel chart based on stages. I created a stage table where I have an order for them and linked to the table I am getting the values.
WHen I try to sort using the tooltips field, it automatically shows up as sum, or count... and therefore, I can't sort by the number itself.
Any tips?
Hi anabianco09
Here is my trying:
My sample:
Merge two tables:
Expand the table to preserve the order column
Select the Category column to sort by the order column.
Result:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi anabianco09
Here is my trying:
My sample:
Merge two tables:
Expand the table to preserve the order column
Select the Category column to sort by the order column.
Result:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Elegant solution Anonymous, I would have done it also with an additional table but your merging of queries works great.
That worked perfectly! Thank you lots!
Can you show the ordering table? How did you link it to the main table?
