2 Replies Latest reply on Oct 31, 2018 9:28 AM by Aleksandra Shander

    #Yes, #No, Total in One Viz

    Aleksandra Shander

      I'm trying to create a viz that shows:

       

      Total incidents closed in month

      How many of total were closed in month they were created

      How many of total were not closed in month they were created

       

      So far, I've got the below viz; it is breaking out the "orange" (does not meet my criteria, aka "No") data set by month created, so for example, using the top/October bar, there are 34 items that were closed in October but created in September, 10 closed in October but created in August, etc.

       

      I've tried a number of configurations but can't seem to get the viz to "group" all the No items as a sum.

       

      For example, for the top bar (October), I want to see 66 (i.e. 34+10+6+6+3+3+1+1+1+1) in orange and 129 in green, and show 195 (66+129) at the end of the bar for the month.

       

      I would also like to understand how to show these numbers as percentages, e.g., using the same numbers as above, see 33.8% (66/195) in orange and 66.1% (129/195) in green.

       

      Unfortunately, I cannot share the packaged workbook because the data is privileged.