Hi,
I am trying to calculate the set analysis below using Advanced KPI extension.
=count({<Date ={">=$(monthstart(max(Date)))<=$max(date))"}, flag={"Agent price"} >}insurance type) * unitprice
I am able to get the value for the below:
=count({<Date ={">=$(monthstart(max(Date)))<=$max(date))"}, flag={"Agent price"} >}insurance type)
However, when I try to multiple the above set analysis with the unitprice , it is not rendering any result.
I appreciate if anyone can help me writing the set analysis with the unit price
