Forum Discussion

anabianco09's avatar
anabianco09
Helper II
2 years ago
Solved

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 toolt...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MNedix's avatar
    MNedix
    Solution Sage
    2 years ago

    Elegant solution Anonymous, I would have done it also with an additional table but your merging of queries works great.

  • anabianco09's avatar
    anabianco09
    Helper II
    2 years ago

    That worked perfectly! Thank you lots!