Set analysis issue

[Anonymous]

Hi,

I have this expression below which is giving a wrong result (No filters selected).

For funnelstamp2 =PQ Close and doc_signed dates selected in that range the value should be 0 for Eloview since there is no record where subscription is <7.

The expression is not taking the filters into consideration. Clicking on the filters makes the value 0.

What is wrong with the expression? Also, the strange thing is that it works when i am giving the subscription >7.

[sunny_talwar]

I am glad it helped. Breaking down the problem into small pieces is the best way to resolve issues such as these

[sunny_talwar]

Now that I think about this, this might also work

Sum({<Doc_Signed = {'>=10/01/2016<09/30/2017'}, [Quote create date] = {'>=07/02/2016<09/30/2017'}, FunnelStamp2 = {'PQ Close'}>} Aggr(

If(Sum({<Doc_Signed = {'>=10/01/2016<09/30/2017'}, [Quote create date] = {'>=07/02/2016<09/30/2017'}, FunnelStamp2 = {'PQ Close'}>} subscription) < 7, (quote_quantity*0.005)), [Quote number], [Elo Project ID], elo_owner Team))

Where you use the same outer aggregation's set analysis as your inner aggregation's set analysis

[Anonymous]

Hi Sunny,

Can you please take a look at this? Thanks!

Chart Design