Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using a date field named Month as a dimension for line chart, and cannot seem to Show Value for the line expression for only the most recent month. I have tried examples posted in this forum previously with no success. My attribute expression is:
=if(Month=(Max(Month), 1,0)
Thanks!
So you have a couple hiccups in your application:
1. Your Month field is not real month, it's fist date of month.
2. You have Month field and a variable with the same name - "Month". When you tries to do your expression, on left side it's variable and on right side it's the field.
I've attached fixed application. I've removed the Month variable. And the expression should be something like this:
=if(Month(Month)= Max(total month(Month)), 1,0)
So you have a couple hiccups in your application:
1. Your Month field is not real month, it's fist date of month.
2. You have Month field and a variable with the same name - "Month". When you tries to do your expression, on left side it's variable and on right side it's the field.
I've attached fixed application. I've removed the Month variable. And the expression should be something like this:
=if(Month(Month)= Max(total month(Month)), 1,0)