How to work with quarter periods in Domo?
SOLVED -- in the date dropdown in the card, you can select to view as quarters and that does the aggregation
I have been prototyping some viz locally using quarters, e.g., 2018Q1 for the raw date of 2018-02-01. It's worked well because in pandas, it recognizes these as time periods. These come into domo as strings, and any ordering is completely lost.
I'm trying to move this into the Domo now and I can't figure out how to replicate this. When I use the QUARTER() function in beast mode to create a new column in the dataset, it returns only the quarter of the year, but not the year, so just one of 1,2,3,4.
Does anyone have experience or advice on how I can get domo to make use of quarters like 2018Q1, 2018Q2 etc... derived from a raw date string?