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

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