Average Require...Finding little bit Tricky

[pra_kale]

Hi All,

I am attaching one sample excel file in that 100 policies are given with their Policy Term and their Product Type.

I just want to know the Average Term for that Product Type..I able to manage to get the answer for (Number of Policies * Term)..but how to find the Average Term segment wise and One summary Table...That I am finding difficult..

1st Requirement is Total 6 Tables are required..

2nd Requirement is Only One Table required which is a summary out-put of this 6 Tables..

In a excel sheet I have put exact calculation and given The Two Requirements..

Please help as I finding little bit Tricky.....

Thanks in Advance..

[MarcoWedel]

‌please post sample app to show how far you have come.

thanks

regards

Marco

[pamaxeed]

Can you provide row data or a sample app?
I think it is not that complicated what you wanna going to achieve...

[kumarkp412]

you can make the calculation(calculate the Average with the group by Dimension ) in script side and make use the measure, dimension  in the chat to get the Average required.

Ex:

In the script side:

Dimension name: Product_type

Load

- - - - -

(Number of Policies * Term) / Total NOP  as Avg

- - - - -

Group by Product_type;

In the front side, use the straingt table and add the dimension as product_type and in the measure use the "Avg".

It will show as  you required the document.

I hope it helps you.

Thanks

Kumar

[pra_kale]

Hi,

Below attached is the application. In that I able to figure out row level Averages but how to take average of a Total that I don't know also working of II second table also little difficult for me.

Thanks in advance for your help.

[pra_kale]

Hi,

Below attached is the application...Average of the Total and II requirement I am finding difficult.

Thanks for your help.

[swuehl]

Maybe like

=Sum(Aggr(Count(DISTINCT {<Product_Type = {'Ulip'}>} Policy_Number)*Policy_Term,Policy_Term))

/ Count(DISTINCT {<Product_Type = {'Ulip'}>} Policy_Number)

[pra_kale · Accepted solution]

Hi Swuehl,

Thanks... exactly the way I want.

[MarcoWedel]

Please mark the solution as correct that answered your question .

Thanks

Regards

Marco