topic Re: Changing date range in bar chart in App Development

Changing date range in bar chart

schuffe — Thu, 27 May 2021 06:18:39 GMT

Hello 🙂

I have the following (simple) problem:

In the following bar chart I want to show the data since 2010.

The formula i use looks like this (working perfectly):

Sum(aggr(Sum(If(Date=RandColumn,1,0))/count(Date), Date))

And now I want to bring in the Filter 'Date > 2009'

So i thought it has to be something like this :

{< YEAR(Date) > 2009 >}

But no matter where I put this condition it's not working.

Can anyone help ?

Thanks 🙂

Re: Changing date range in bar chart

GaryGiles — Thu, 27 May 2021 12:32:07 GMT

A couple of issues with your set analysis. First, you can't use a function like Year() as the left side of a comparison. You would need to create a Year field in the load scripts to filter on Year in set analysis. Second, the correct syntax for using greater than in set analysis would be is {$< fieldname={">2019"} >} :

For now, you could try: {< Date={">01/01/2019"} >}

Re: Changing date range in bar chart

schuffe — Thu, 27 May 2021 12:28:46 GMT

Thank You, that's working 🙂