Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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"} >}
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"} >}
Thank You, that's working 🙂