Group by → April, May, ...December, January, February, March (not January, February, ..., December)

In AppSheet, I want to group by month using the Group by setting, with the months January to December. However, instead of displaying them in the order January, February,… December from the bottom, I want to display them in the order April, May,… December, January, February, March. The month column is of Ref type and refers to a Month Master table.

One way is to use number before the real month name so it will sort the order based on that.

2 Likes

Thanks

Like 0_April, 1_May, 2_June, … , 8_December, 9_January, …???

It’s awkward to have this notation even when displaying groupings, but is it unavoidable?

Cria uma coluna virtual e usa como numero e usa essa formula !

SWITCH(
MONTH([DATA DA COMPRA]),
1, "JANEIRO " & " " & YEAR([DATA DA COMPRA]),
2, "FEVEREIRO " & " " & YEAR([DATA DA COMPRA]),
3, "MARÇO " & " " & YEAR([DATA DA COMPRA]),
4, "ABRIL " & " " & YEAR([DATA DA COMPRA]),
5, "MAIO " & " " & YEAR([DATA DA COMPRA]),
6, "JUNHO " & " " & YEAR([DATA DA COMPRA]),
7, "JULHO " & " " & YEAR([DATA DA COMPRA]),
8, "AGOSTO " & " " & YEAR([DATA DA COMPRA]),
9, "SETEMBRO " & " " & YEAR([DATA DA COMPRA]),
10, "OUTUBRO " & " " & YEAR([DATA DA COMPRA]),
11, "NOVEMBRO " & " " & YEAR([DATA DA COMPRA]),
12, "DEZEMBRO " & " " & YEAR([DATA DA COMPRA]),
“Invalid”
)

If you can use an Enum column and you manually add your months in a correct order in “Values” option, your grouping will follow that order.

3 Likes

This has stopped working for me. When I asked Support about it, I was told this (now-seemingly-broken) behavior is correct and intended.

1 Like

Yes, I also tested setting up an enum because I wanted to respond to this question. But I also could not get it working.

This is the enum I had created. :slightly_smiling_face:

1 Like

I tested and for me it works just fine.

Okay Aleksi. Thank you for the confirmation. I will retest tomorrow and revert. Maybe I missed some obvious point in my configuration.

I tested this with another account and it didn’t work. I have a vague memory from 3…5 years ago that my personal account was excluded from the rollout and that’s why the behavior is different.

How would I get mine fixed? What language would Support respond to?