Type of object

Drop-down selector

Object version

Available from ODT version v2009031045

Preview

Subscription

  • Sales & Marketing

  • Territory Management

  • Use And Analytics

Operation

The arrangement of the columns

The sort drop-down selector object allows "to arrange" as you wish on the one hand the display order of " Time Range ", " Time Group "and" Measure ".

  • " Time Range " (in orange in the illustration below) corresponds:
    > to chronological order: June, July, August, September ....
    > anti-chronological order: September, August, July, June ...

The "Time Range" sorting is therefore dependent on the "Time Group" selection (it is quite possible to select YTD Sep 2020, YTD Sep 2019, MAT Sep 2020, MAT Sep 2018 ).

  • " Time Group " corresponds to the time groups of type MAT, YTD, C (cycles), Mth ... (in green in the illustration below )

  • "Measure" corresponds to the Turnover, Turnover Evol, Volume ... type measure (in blue in the illustration below)

The order of the columns

The order of the 2 types of temporal sorting can be ascending or descending for each of them (represented by the arrows) .

Examples

We must see the sorts as "encapsulated" in each other.

- Tri Time Group (descending), Measure, Time Range (descending):

Here what changes first is the "Time Range" (chronological order) within the selected "Time Groups".

Second, what changes are the metrics (Turnover, Trunover Evol, Turnover Evol Abs)

Third, the most "macro" sort is the "Time Group" (YTD, MAT, C1 2020, Q3-2020-QTD, Mth (s) in descending order.

Are schematized in the screenshot opposite in underlined, the "toggle", for a given sort, allowing to highlight the finest level, the intermediate level and the most macro level.

- Tri Time Group (descending), Time Range (descending), Measure:

Here, what changes first from one column to another are the "Measures".

Then going up the level above, we have the "Time Range" (in descending order), which corresponds to the anti-chronological order.

Finally the 3rd sorting group, the "Time Group" corresponds here to the distinction between YTD, Mth.

Limitations

  • The display order of the measures in column (the fact that "Turnover" comes before "Turnover Evol" for example) remains fixed .

  • By default, the sort is fixed at the row (dimensions) on the values Sell-Out MAT descending

Did this answer your question?