Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to find the distinct supplier and average of count of contractor name. I want expression which will give the average value as 15 from the below table
Example
Supplier count of contractor name
A 10
B 20
Not sure what is wrong with below expression
avg(DISTINCT {<[Supplier] = {"=Count([Contractor Name]) =-{*"}>} [Supplier])
Please help
Regards,
Savithri
I'm not sure if you have a reason for writing the aggregation into the set analysis, but if you do, you can probably modify this accordingly. Either way, you will have to use aggr() to nest two aggregations.
avg(Aggr(Count(distinct [Contractor Name]),[Supplier]))
Or may be this
Avg(Aggr(Count(DISTINCT Supplier), [Contractor Name]))