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
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

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    JCovelli see attached, I guess tht will help. You can slicer the graph by category or division, and it will compare against total calls.

  • JCovelli's avatar
    JCovelli
    Helper I
    7 years ago

    Thanks so much for sending a solution!  I am excited to open it- I am unfortunately constrained here at work with downloading the newest version of Power BI Desktop, and your version must be newer than mine, because I am unable to open the file.  I will try to download the newest version at home so I can open your file.  Thanks for your help!

     

    John