Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have one query. As per below chart "Average farmers reporting per day" for Total is 36.8 which is correct..
Supervisor wise average is also correct which is calculated as per below formula -
Total Farmer Reach Count/ count of unique dates
But is there any possibility that I can show average of all supervisors average which is 7.1
So how can be is possible ? because I want to highlight all supervisors who are meeting farmers below of overall average.
try to use dimensionality function
if(dimensionality()=1,
avg(aggr(sum[Farmer Reach Count]/ count(distinct floor(mydate)), [Supervisor Name])),
sum[Farmer Reach Count]/ count(distinct floor(mydate)))
may be in background color you can put below expression
=if( avg(aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])) <
sum([Farmer Reach Count])/count(distinct floor(mydate)), lightred())
or
=if( avg(aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])) <
avg(total aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])),lightred())
hi
it should be something like
avg(aggr(Total Farmer Reach Count/ count of unique dates ,Supervisor Name))
Hi,
I have applied formula as below -
=avg(aggr(sum[Farmer Reach Count]/ count(distinct floor(mydate)), [Supervisor Name]))
but below output is coming -
try to use dimensionality function
if(dimensionality()=1,
avg(aggr(sum[Farmer Reach Count]/ count(distinct floor(mydate)), [Supervisor Name])),
sum[Farmer Reach Count]/ count(distinct floor(mydate)))
Thanks a lot Kuch.. Really you are champ !!
Below formula worked correctly -
if(dimensionality()=1, avg(aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])),
avg(aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])))
Hi Kuch,
Adding to this, now I want to highlight all the supervisor wise average values which are lesser with overall average.
How can I do it?
may be in background color you can put below expression
=if( avg(aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])) <
sum([Farmer Reach Count])/count(distinct floor(mydate)), lightred())
or
=if( avg(aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])) <
avg(total aggr(sum([Farmer Reach Count])/count(distinct floor(mydate)),[Supervisor Name])),lightred())
Second expression worked perfectly. Thanks a lot