topic Re: Count of Growth Label in Archived Groups

Count of Growth Label

zain16nib — Tue, 22 Jul 2025 17:59:49 GMT

Hi,

i need to create a Report 2, format which is given in attached excel file.

kindly guide,

application and data file has been attached.

Thanks in advance,

Regards,

Zain.

Re: Count of Growth Label

zain16nib — Fri, 02 Nov 2018 16:58:44 GMT

i want to do this in dashboard not in script, i know this script level.

Thanks,

Zain.

Re: Count of Growth Label

zain16nib — Fri, 09 Nov 2018 04:17:50 GMT

waiting for reply

Re: Count of Growth Label

Anil_Babu_Samineni — Fri, 09 Nov 2018 14:57:56 GMT

How below are calculated?

0-50	2
above 50	3

Update - My Bad, Why you want only Front End??

Re: Count of Growth Label

sunny_talwar — Fri, 09 Nov 2018 15:04:33 GMT

Try this

Dimension

=Aggr(
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)<0,'Negative',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)=0,'Zero',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)>0 and (((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)<=50,'0-50',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)>50,'above 50'))))
, br)

Expression

=Count(DISTINCT br)