1 Reply Latest reply on Dec 5, 2012 3:05 PM by matt.keranen

    Ratio calculation in a stacked, binned barchart (histogram)?

    matt.keranen

      I have a simple stacked barchart for two categories (active and inactive), with columns as bins of age in days, and rows as the distinct count of customer IDs.

       

      I would like to add a ratio of the categories (inactive / active), but I am unable to calculate it because the categories are "isolating" the groups.

       

      For example, if I attempt to SUM(IIF(active='Y',1,0)) and SUM(IIF(active='N',1,0)), I get separate rows for Y and N with one or the other always being zero.

       

      Is there another approach to adding a ratio to this type of chart?