2 Replies Latest reply on Sep 19, 2016 3:05 AM by david marcus

    building a scatter chart with % on time vs totals

    david marcus

      Hi

       

      I'm trying to build a simple scatter chart showing timeliness vs total number of cases. A case can be done in time (met the statutory deadline) or late but I cant work out how to get the "% who met deadline" on one axis and the total for ALL cases handled (not just those that met the deadline) on the other axis. I suspect I need to build some calculated fields but cant work them out. I do also want to be able to filter by sector and year, if that affects the approach needed.

       

      Any advice much appreciated.

       

      thanks

       

      David M