Count Help

[Anonymous]

Hi All,

I am having a following fields ,Service Name, Application name . And I need to find out which service having more than 2 Applications.

I have used Count(if(Applicationname)>2,Applicationname)

also

Count({<Applicationame={<'>2'>}>}Applicationname)

Kindly share your thoughts

-Jay

[anbu1984]

If(Aggr(Count([Application name]),[Service Name])>2,Count([Application name]))

[Gysbert_Wassenaar · Accepted solution]

Create a straight table

Use Service Name as dimension

Use as expression =count({<[Service Name]={'=count([Application name])>2'}>} [Application name])

[PrashantSangle]

Hi,

Try like,

Count(if(count(Aggr(ApplicationName,ServiceName))>2,ServiceName))

Regards

[Anonymous]

if (aggr(count(AppName),ServiceName)>1,ServiceName)