Yes, I want to apply this expression in a filter pane, so our sales team can filter on red and green dots.
The Aggr function did solve my problem, so many thanks for that!
Could you shortly explain what the Aggr function exactly does in this example?
And does this expression also work within the load script, so I can create this flag as a dimension?
Check this article, yes we can do backend script aswell
There are many ways you can do it
1) Color code using inline load script
2) if your re-using this prompt in your application better create master dimension and easy to call all the sheets.
That helps to understand the function, thanks!
Now I'm trying to create the same flag in the back end, but I'm getting stuck.
Could you show an example of using a group by clausule with the same field names?
I prefer to have this as a dimension in my load script, because I'll have to use in multiple apps..