Created histogram using examples found in other posts… Started using a VC with forumula Month([DATE]), to create the graph. This works, but months are shown by numerical value. Changed formula to: TEXT([Date], “MMMM”), so the friendly name would be shown. When graphed, the results are correct, but the months are no longer in order.
Is there a way to combine these two formulas such that the numerical order is preserved and the friendly month names are shown?
Create a Months table that has the Month Number as the key and a column for the textual name. Set this textual column as the Label column in the table.
Then assign your Virtual Column back to the original formula but as type of Ref and sort on this column as you did before. Sorting will occur on the row key but the Chart will display the Label value.
You could create a column of type Enum where you input the Months in the “Values” section respecting the order and AppSheet will consider this as the order for those column values.
The fastest way would be to just change your current column to Enum and write the values inside the column config.
The AppFormula is going to pick one of those automatically
