Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the followin expression:
avg(aggr(count({$<Sales={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))
I have this in a chart showing bars for each Team. But when i select a Team only one bar i showing and that's not what i want, the chart must remain the same (hence, showing all teams(bars) despite the selection of team. It worked fine with this expression sum({$<Signt = , Team = , Name= >} Points) so i'm thinking it's the aggr function that doesn't like this.
Any ideas how i solve this?
Thanks!
//A.
Hi,
At a first glance, you may need to add
avg({1} aggr(count({$<Sales={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))
The {1} part to indicate all possible values. You may try the 1 instead of the $ in the Count() function as well, instead of setting all fields equal to nothing
Hope that helps.
BI Consultant
Hi,
At a first glance, you may need to add
avg({1} aggr(count({$<Sales={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))
The {1} part to indicate all possible values. You may try the 1 instead of the $ in the Count() function as well, instead of setting all fields equal to nothing
Hope that helps.
BI Consultant
worked great! Thanks!