How does one do aggregations or filtering in a report? Using referend Parent-Child tables this is straight forward.
Howeven when one uses Slices to filter data, it seems one cannot use the Parent-Child referecing any longer.
Using SELECT or FILTER seems to not work in Slices as well. Any ideas? +Tony Fader
@Eduardo_Lopez Itโs easier to test your expressions as virtual columns instead of putting them directly in your template. Thatโs just general advice.
More concretely, you can use things like this in the parent table:
SELECT(Children[Key], AND([Ref column] = [_THISROW], [Some child column] = โSome valueโ))
@tony thank you kindly
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |