When using custom calculated fields in dashboard not able to sort descending most recent Wk/Mo/Qtr

Question & Answer
1

For custom calculated fields used in the same view, dashboard does not allow to order DESC by most recent Yr-Week combination to show far left.
If used one metric at a time and any dimension works fine.
I can only order Year DESC.
Customer feedback:

  • it takes 5 min to try to find wk 22
  • if you manage to find the column, then you lose it again when you scroll down since the first row is not frozen
  • scrolling is impossible
2

Hi @lrromans

Can you sort on your timestamp field if you have one?

Or make a timestamp from your fields?

1 Like