How to :: manage data order in your storyĀ¶

OverviewĀ¶

You can force a certain layout/order of your insights in your graph. By default, it will be the alphabetical order.

šŸ“ Iā€™m analyzing the number of people visiting my mall by day. So Iā€™d would like to order my data by the day of the week. The day of the week are contained in the label column of my data file.

Sort valuesĀ¶

For some charts you can select a default order from the chart parameters menu. Ascendant or descendant.

šŸ“ Do I want to identify first the worst performers? or the best ones? What decision should I be able to make?

sort

sort

Configure order from a columnĀ¶

Warning

This is only available from the code mode.

From the code mode you can also set the order of your values from a column.

Do you want to order your labels? groups? or packs?

Just add a

  • labelsOrder: ""
  • groupsOrder:""
  • packsOrder:""

in your charts section. Just fill the "" with the name of the column containing the order. It can be a int or str column, by default it will be asc and alphabetical order.

Configure order from a listĀ¶

Warning

This is only available from the code mode.

From the code mode you can also manually set the order of your values.

Just add a

  • labelsOrder: [""]
  • groupsOrder:[""]
  • packsOrder:[""]

in your charts section. Just fill the [""] with the literal value of the label/group/pack. Separate values with , and add them in the order you wish them to be displayed.

šŸ“ I want to see Paris first, what ever the value is. I would use labelsOrder : ["Paris"]

šŸ“ I want to see Paris first, then Monaco, what ever the values ares. I would use labelsOrder : ["Paris", "Monaco"]