Previous 12 Months

[#1]

Apologies if I have duplicated other threads but I have had a look through and could not find the answer or better still understand the concept

In my document I have a graph on the details tab which has been setup to look at the previous 12 months from the previous month back.

I want to now convert this to current month (so it updates when data is refreshed).

How do I amend the expression below so that it updates and also 0 values are shown. I have a master calendar setup

({$<DateRaised={">=$(=addmonths(monthstart(today()),-13)) 00:00:00 <=$(=addmonths(Monthend)today()),-2,1) 23:59:59"},ValueID={'*24*'}, IncidentType={'*Accident*'}, ListTitle={'*Employee*'}>}ValueID)

Thanks again in advance

[#2]

I forgot to mention, there is no data for December 14 as an example, but I want it to show up as 0 on the graph (same as May 15)

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#4]

Thank you Gysbert,

I can see what you have done but is there a way to show 0 on the graph?

[Gysbert_Wassenaar]

Enable the Zero on Bars option on the Presentation tab.

[#6]

Fantastic!!

Thank you so very much for your time and patience helping me with this