0

Order values in funnel charts

Hector Perez-Nieto

June 08, 2016 07:11

None

Follow

Hi,

Is it possible to sort the values in a funnel chart in some way other than alpha? Say I have:

• Call
• No Answer
• Answer
• Sale
• No Sale

(just hypothetically)

How could I sort them in this specific order?

Many thanks

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Philip Harrison December 13, 2018 09:28

  Also looking to do the same thing, any chance somebody has come up with a nice way of ordering the Labels for a Funnel chart?  Could probably prepend numbers to each label (like "1. Closed Won", "2. Closing") and then sort alphabetically but feels like a bit of a hack.

• 0
  
  Janice Janczyn December 13, 2018 14:59

  Hi there!

  If your data is not grouped (hard-coded), you can simply leave your Labels unsorted, for example:

     Labels - ARRAY("Call,No Answer,Answer,Sale,No Sale")
     Values - an array of 5 corresponding values

  More typically, your data will come from a datasource and need to be grouped and sorted. To sort your data according to a fixed order, add Hidden Data to do the mapping from label to order value. For example, if your values are in column B and your labels are in column A:

     Values - B:B
     Labels - A:A
     Hidden Data: SWITCH( A:A, "Call", 1,
                                                   "No Answer", 2,
                                                   "Answer", 3,
                                                   "Sale", 4,
                                                   "No Sale", 5)

  Then, using the Actions menu:

  1. Group the Labels.
  2. Set the Aggregation method as needed for the Values.
  3. For the Hidden Data, set the Aggregation method to First .
  4. Sort the Hidden Data.

   

  Hope this helps!

   

  Thank you,
                 Janice

• 0
  
  Philip Harrison December 13, 2018 15:23

  That worked perfectly thanks Janice!