Hi, I currently have some sales data with the date that the sale was made in a date&time format.
I was wondering if there was a way to sort and visualize the number of sales made per month.
@Leongwd you could extract the year and month and combine them into an integer or string like this:
YYYY-MM
YYYYMM
Then a group by or pivot node might help.
3 Likes
@mlauber71 Thanks, it worked and this is what I get, but is there a way to sort the rows via Month as well, for example January, February, March, etc.
1 Like
@Leongwd you could extract the months’ numbers and add a leading zero in a string like in the second example. You might add the year as well.
2 Likes
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.