How can I sort by days of the week / months of the year in Remarkable?

FAQs
1

How can I sort days of the week in the correct order (Mon–Sun) in a table?

If you can’t sort by a field that isn’t displayed, the recommended workaround is to map to a dimension that already includes the sort key.

Example approach

  1. Create a new dimension in your model that prefixes the label with a numeric sort value, for example:

    • 01 - Monday

    • 02 - Tuesday

    • …

    • 07 - Sunday

  2. Use this new dimension in the table (so sorting works correctly).

  3. Translate the displayed label via your theme so users only see Monday, Tuesday, etc.

This ensures the table sorts correctly (by the numeric prefix) while still showing clean day names to end users.

Why do I need to change the dimension instead of sorting by a hidden field?

In some setups, sorting is only available on fields that are actually used in the visualization. By embedding the sort value into the same dimension you display, you avoid needing a separate “hidden” sort field.

Can I keep the numeric prefix from showing to users?

Yes — after you create the prefixed dimension (e.g. 01 - Monday), you can add a theme translation that maps:

  • 01 - Monday → Monday

  • 02 - Tuesday → Tuesday

  • etc.

So you get correct ordering and clean labels.