Hi,
I have the following expression:
sum({$<Signt = , Team = , Name = >} Score)/
if(Team='Blue', avg({1} aggr(count({$<Created={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))*0.78,
avg({1}aggr(count({$<Created={'>0'}, Signt = , Team = , Name= >} distinct Signt), Date, Team))
)
This expression shows the average score per day per Name/Signt over the chosen dates.
In my case where the problem occured, i've chosen one date.
But if a choose a Name that doesn't belong to the Blue team, the rule for the blue team doesn't apply.
How can i write this so that i can chose a Name/Signt but without having it effect the chart.
Thanks in advance!