Here's the workaround we came up with for quarterly grain to come through in order:
In ETL -
Use datepart function to isolate year and quarter.
Combine year and quarter columns with Q as the character separating the values.
Because this results in a text output, it will sort properly by default.
Of course - we will all be thrilled when the official fix is deployed, but this can help anyone in an immediate bind.
If you believe that you are experiencing a bug within Domo, I would advise that you get in touch with your Domo account team for support. Make sure to include the link to your card, and also any errors you are seeing.
This is communicated to domo technical team as didnt receive any quick response here.. thanks for your reply.
Your post doesn't really give enough information to hazard a solution. If you don't quickly get a solution from support, perhaps you can post some screenshots or more information about the issue you are facing.
One thing that comes up a LOT is date format. So - First thing is to make sure the date field is in date format. If it was working before and suddenly isn't, it could be a format change from an iterative update or something.
I am having the same problem. I can sort dates, text, numbers, etc. But if I use a date grain I am unable to sort.
Is the field you're trying to sort in Date format or Text format?
I'm having the same problem. I added a date grain to view by quarter but the quarters aren't in order. I'm sorting the rows by Total Commissionable Sale. I just want the date columns to be in order.
Sort by Date then Sales. If that doesn't work, do the opposite.
I can webex with you this afternoon and explore it with you, if you'd like. What time zone are you in?