Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to select minimum value from my fiscal year column FY16 and FY17 and store it in a variable. But then when I select a value in the fiscal year filter the variable's value gets changed
if you want to fix this value and should not affect from any selection then you can use
Max({1}YearField)
Use it according to your expression
if you want to fix this value and should not affect from any selection then you can use
Max({1}YearField)
Use it according to your expression
create a variable and in let the definition starts with = sign
and the definition would look like something like this:
=Max({1}year)
where {1} is the whole set of data regardless of any selection you make on the dashboard
Hi Shraddha,
Its working fine the value of my variable is fixed, but due to this other filter selections are not working.
can you share a sample application to investigate it
Max({<YearField=>}YearField)