Forum Discussion

JCovelli's avatar
JCovelli
Helper I
7 years ago

Category Comparison Graph

  Hey Everyone, I would like to compare our categories of Call Intent Types by day, looking at one particular category’s calls versus the total calls.  I would also like to do this comparison by Di...
Need Help
JCovelli's avatar
JCovelli
Helper I
7 years ago

Thank you parry2k!  I just pasted into a post...at work, unfortunately I do not have access to the other filesharing mechanisms you mentioned.

 

John

parry2k's avatar
parry2k
Super User
7 years ago

JCovelli is this how your raw data looks like? Please confirm. It need to unpivoted and than everything will work great. 

  • JCovelli's avatar
    JCovelli
    Helper I
    7 years ago

    I had actually mocked up a version of the aggregated data to illustrate.  But I see now you want a raw set.  I tried to mock up a set of raw data, but now I am getting a meesage when I psate it that I am exceeding 20,000 characters...

    • JCovelli's avatar
      JCovelli
      Helper I
      7 years ago

      Date

      Division

      Category

      		 

      1/1/2018

      Division One

      Address Change

      1/2/2018

      Division Two

      Address Change

      1/3/2018

      Division Two

      Address Change

      1/4/2018

      Division Three

      Address Change

      1/5/2018

      Division One

      Billing

      		 

      1/6/2018

      Division Two

      Billing

      		 

      1/7/2018

      Division Three

      Billing

      		 

      1/8/2018

      Division One

      Billing

      		 

      1/9/2018

      Division Two

      Claims

      		 

      1/10/2018

      Division Two

      Claims

      		 

      1/1/2018

      Division Three

      Claims

      		 

      1/2/2018

      Division One

      Claims

      		 

      1/3/2018

      Division Two

      Complaints

      1/4/2018

      Division Two

      Complaints

      1/5/2018

      Division Three

      Complaints

      1/6/2018

      Division One

      Complaints

      1/7/2018

      Division Two

      Address Change

      1/8/2018

      Division Two

      Address Change

      1/9/2018

      Division Three

      Address Change

      1/10/2018

      Division One

      Address Change

      • JCovelli's avatar
        JCovelli
        Helper I
        7 years ago

        1/3/2018

        Division Two

        Billing

        1/4/2018

        Division One

        Billing

        1/5/2018

        Division Two

        Billing

        1/6/2018

        Division One

        Billing

        1/7/2018

        Division Two

        Billing

        1/8/2018

        Division Three

        Billing

        1/9/2018

        Division One

        Billing

        1/10/2018

        Division Two

        Billing

        1/1/2018

        Division Three

        Billing

        1/2/2018

        Division One

        Billing

        1/3/2018

        Division Two

        Billing

        1/4/2018

        Division Three

        Billing

        1/5/2018

        Division One

        Billing

        1/6/2018

        Division Two

        Billing

        1/7/2018

        Division Three

        Billing

        1/8/2018

        Division One

        Billing

        1/9/2018

        Division Two

        Claims

        1/10/2018

        Division Three

        Claims

        1/1/2018

        Division Two

        Claims

        1/2/2018

        Division Three

        Claims

        1/3/2018

        Division One

        Claims

        1/4/2018

        Division Two

        Claims

        1/5/2018

        Division Three

        Claims

        1/6/2018

        Division One

        Claims

        1/7/2018

        Division Two

        Claims

        1/8/2018

        Division Three

        Claims

        1/9/2018

        Division Two

        Claims

        1/10/2018

        Division Three

        Claims