How does one do aggregations or filtering in ...

(Eduardo Lopez) #1

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

(Tony Fader) #2

@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”))

(Eduardo Lopez) #3

@tony thank you kindly