Forum Discussion
Solved
Grouping Data
Hello! I'm trying to group my order dates into quarters. Currently it is showing each individual date an order was placed in this format 2023-10-19. I want to be able to group them by month and quar...
Hi,
In the Query Editor, seperate that column into 2 - one with Date and another with time. Now build the Calender Table.
lbendlin - thank you for the quick response but can you explain this to me? I did follow your instructions and create the new query and once I was finished it did display 2 dates. How am I supposed to use this to fix my issue?
Use my code as a guidance (split by delimiter, throw away right part).
Replace the Source= line with your own source. Adjust column names as needed.