Forum Discussion

hans3400's avatar
hans3400
Helper I
3 years ago

Top N when year changes

Hi

I have a bar chart that shows how many invoices is being created on a monthly basis. I have a data set that goes back to Jan 2022. 

 

I only want to show the last 5 months in the report and so far it has worked fine. I have added the number for Jan 2023 and now the bar chart adds Jan 2022 and Jan 2023 together which is not what I want. I want it to show Sep, Oct, Nov, Dec and Jan which is the last 5 months. How can I do that?

 

Bar chart is set up this way: 
X-axis is month (value of date column is written like this: 2022 01, 2022 02, 2022 03 etc.)

Y-axis is number of invoices

 

Filter on date (month): Top N: Top 5 by value Latest Month.

 

I hope someone can help. 

 

Cheers