Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
See attached qvw.
Thank you Gysbert,
I can see what you have done but is there a way to show 0 on the graph?
Enable the Zero on Bars option on the Presentation tab.
Fantastic!!
Thank you so very much for your time and patience helping me with this