Hi All,
i want to display 3 months values trend using below expression and variables, i tried with below expression im getting "0" value, Any expression Suggestions.
variables:
MonthName(Date) as Metric_Month
vMaxDate=monthname(addmonths(max(Date),0))
vMaxDate2=monthname(addmonths(max(Date),-2))
Expression:
=Count(DISTINCT{<Month=,Metric_Month={">=$(=vMaxDate)<=$(=vMaxDate2)"}>}value_id)
Thanks & Regards,
NR
