Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

unexpected matrix sort

I'm getting this error in data view when attempting to sort 'Metric desc' by 'Order' with the goal of displaying the 'Metric Desc' data in the requisite order without displaying the 'Order' column it...
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    In your data, the same Metric Desc can have two Order values. If you set the column Metric Desc to be sorted by the Order column, for example the value " • Current number of phones ported" has two orders 2 and 9, it can't be determined whether the value "• Current number of phones ported" should be sorted based on 2 or 9. So it's expected that you get that error message. 

     

    You can modify your data, then you can set the column Metric Desc to be sorted by the Order column. See: 

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi Anonymous,

 

In your data, the same Metric Desc can have two Order values. If you set the column Metric Desc to be sorted by the Order column, for example the value " • Current number of phones ported" has two orders 2 and 9, it can't be determined whether the value "• Current number of phones ported" should be sorted based on 2 or 9. So it's expected that you get that error message. 

 

You can modify your data, then you can set the column Metric Desc to be sorted by the Order column. See: 

 

 

Best Regards,
Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for pointing that out. Turns out that I failed to notice there were repeating values in the Metric Desc column.