Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
How do I limit the data in graphs to last 30 days,
I added a condition as , =Date(today())-Date(floor([Date Created]))<=30, however it then gives me below
THanks,
Rains
I got this,
disable the "Continuous" auto in the X-axis or Y-Axis
and then I was able to uncheck the "Include null values".
Hi,
Try this.
Create a measure:
Sum({<CreateDate = {">=$(= Date(Today()-30, 'DD/MM/YYYY'))"}>}YourDimension)
Edit your date format
Thanks
Hi,
I did limit it with a calculation, the problem is it is working in a bar chart but not on line chart now, as I am not able to limit null values,
I got this,
disable the "Continuous" auto in the X-axis or Y-Axis
and then I was able to uncheck the "Include null values".