Six month average count and interval

[sunil-kumar5]

Hi All,

I have two table as list of partners and second how many installation they have done so far,

Partner Table columns total rows(2000)- PartnerName, Dateofjoining(as when they have associated with us), partnerid,

Installationtable column total rows (300000)- partnername,installationnumber(A unique number at the time of installation),partnerid

On the basis of this information I have to create below table, I am stuck in the ('Last 6  months Avg Activation Slab wise Partner Count') part which has interval category of installationnumber like 0,1-3 and so on of last six month average, and below that there is a count of partner's id as how many partner falls in that interval category,

Please advise.

Thanks

[Anil_Babu_Samineni]

Hello, Since you need your own way try like

If(installationnumber=0, Dual(0, 1), If(installationnumber>0 and installationnumber<=3, Dual('1-3',2), ...)

[sunil-kumar5]

Hi Anil,

I also need to know as how I can put the onboarded partners count in that interval.

Please advise.

Thanks

[Anil_Babu_Samineni]

I see that you need in GUI, If so you can use created field as dimension and expression is Count(..)