1 Reply Latest reply on Mar 21, 2017 4:30 PM by diego.medrano

    Calculate number of records inside of sets and show on chart

    Aliaksei Razumau

      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.

       

      What is the way to do it?