KPI

[Anonymous]

Hi All,

story	substory
story1	substory1
story1	substory2
story1	substory3
story2	substory1
story2	substory3
story2	substory2
story2	substory4

i want story name in KPI front end. which is having max no. of sub stories.

Thanks & Regards

[Anil_Babu_Samineni · Accepted solution]

Try this?

=FirstSortedValue(story, -Aggr(Count(substory), story))

[sunny_talwar]

What would you want to see if two stories have same number of substories? Would you want to see one of them randomly? You can try this

=FirstSortedValue(DISTINCT story, -Aggr(Count(substory), story))

See both separated by comma?

=Concat(DISTINCT Aggr(If(Count(substory) = Max(TOTAL Aggr(Count(substory), story)), story), story))