topic Re: Limit data in graph for last 30 days in App Development

Limit data in graph for last 30 days

tvisha — Mon, 15 Aug 2022 11:16:51 GMT

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

its_rajvir — Mon, 15 Aug 2022 12:00:26 GMT

Hi,

Try this.

Create a measure:

Sum({<CreateDate = {">=$(= Date(Today()-30, 'DD/MM/YYYY'))"}>}YourDimension)

Edit your date format

Thanks

tvisha — Mon, 15 Aug 2022 12:16:06 GMT

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,

tvisha — Mon, 15 Aug 2022 12:21:48 GMT

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".