I've created multiple sets (which a based on cross fields formula) and want to calculate or show number of records for each set on one chart.
What I've tried so far:
1. Set returns in/ out and not results directly, doing count(set) or window_count(set) returns error.
2. Doing countd(if set then 1 else 0 end) returns 2 which represent counting in/ out dimensions.
3. I could pull one set to row and then calculate number of records by countd(id_for_each_record) which worked! but when I add another set to rows it creates a combined set and doesn't display side by side.