Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a range of years in my data from 01/01/2000 and 01/01/2017, but I want to 1) limit the table to displaying only the last 7 seven years and 2) only display the year. I've tried all sorts of expressions, but can't get it right. Sometimes the Expression Editor displays a syntax error, sometimes it does not, but when I click apply, I see "Invalid Dimension" in the table. How can I make this work?
Thanks
Hi Lorenzo,
Not sure that I follow what you try to do, but here:
When creating the dimension in your chart you could use the following expression
=If(Num(Year(DateField))>=$(vYearFrom),Year(DateField))
Which needs that you had created the following variable inyour script:
Let vYearFrom = Num(Year(Today())) - 6;
Cheers,
Luis
Hi Lorenzo,
Not sure that I follow what you try to do, but here:
When creating the dimension in your chart you could use the following expression
=If(Num(Year(DateField))>=$(vYearFrom),Year(DateField))
Which needs that you had created the following variable inyour script:
Let vYearFrom = Num(Year(Today())) - 6;
Cheers,
Luis
Thank you, this is precisely what I'm looking for.