8 Replies Latest reply: Aug 31, 2012 10:24 AM by Rebecca Molstad RSS

    Extract Data into a Bar Chart

      Hi,

       

      I am trying to enter certain information into a bar chart.  I have a field called Fix Code and what I am looking to do, is depending on the first four letters of the fixcode, will represent what type of issue this is.

      We have the following example information in the fixcode field:

       

      FLT0-CRPR-RCL0-SSWO

      FLT0-CRPR-RCL0-STNT

      RQST-NS01-SS01-TTRT

      RQST-FST-RRCL-THR1

       

      What I am looking to do is if the first four letters = FLT0, we will call it Fault

      If the first four letters are = RQST, we will call it Request.

       

      I want a bar chart that displays the total amount of Fault (FLT0) calls and the total amount of Request Calls (RQST) together.

       

      Therefore I am hoping my Bar Chart will show 2 columns one with Fault showing say 80 calls and one with Request showing say 200 calls.

       

      Is this Possible?