Filtering data by month

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.

Screenshot (80)

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.