Forum Discussion

cosminc's avatar
cosminc
Post Partisan
8 years ago
Solved

multiple sort

Hi, how can a do a multiple sort after client, date and time in this order? thanks Cosmin
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi cosminc,

     

    Nope, these option also works on dynamic datasource.
    Please sort columns before add index column, then records will get correct index even if updated dynamically.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello,

 

You can sort 2 columns by giving rank to 2 columns and later sort based on rank.

 

Thanks,

Aditya

cosminc's avatar
cosminc
Post Partisan
8 years ago

if i understood you say from a query editor to sort date - create a column with rank, after that sort start time and create a column with rank and after that to concatenate there 2 rank columns and sort in in visualisation after this? but it is a dynamic source, it is updated daily, i think it's not works.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi cosminc,

     

    Nope, these option also works on dynamic datasource.
    Please sort columns before add index column, then records will get correct index even if updated dynamically.

     

    Regards,

    Xiaoxin Sheng

    • cosminc's avatar
      cosminc
      Post Partisan
      8 years ago

      Thanks

      Cosmin