Set Analysis using Advance KPI extension

Kunal_Uppal — Tue, 05 Jul 2022 01:19:49 GMT

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

Re: Set Analysis using Advance KPI extension

Kunal_Uppal — Tue, 05 Jul 2022 02:28:04 GMT

I don't have the Sales amount in the table. I have the data on insurance level, so I would like to calculate the total sales by multiplying with unitprice.

topic Set Analysis using Advance KPI extension in App Development

Set Analysis using Advance KPI extension

Re: Set Analysis using Advance KPI extension