Skip to Content
0
Jul 28, 2023 at 08:01 AM

Sort table by date in SAP Analytics Cloud stories

62 Views

Hello!

I am trying to sort a table in a SAC history but the order is wrong for two reasons

image.png

  1. Sort the dates alphabetically, starting with April instead of January.
  2. Sort the numbers as if it were a string of characters by placing 10 after 1, instead of 2.

The dimension is automatically loaded in the model as a date with day granularity and with the correct hierarchy;

image.png

And when I open the dimension it does sort correctly:

image.png

What could I do to order it correctly in the story?

Thank you very much

Attachments

image.png (20.3 kB)
image.png (10.1 kB)
image.png (10.1 kB)
image.png (28.7 kB)