I have two datasets.
The first has the dealers name with how many accounts they have.
For example:
Company name | Total # Accounts |
Company A | 1990 |
Company B | 450 |
Company C | 3000 |
The second shows all of the alarms for a given period and which account and dealer they are for.
For example:
Alarm Date | Account # | Company Name |
1/15/2016 | H12345 | Company A |
2/16/2016 | J4321 | Company A |
1/2/2016 | K98444 | Company B |
1/25/2016 | LO48354 | Company C |
1/12/2016 | HJ32454 | Company A |
I want the card to be able to show me the total number of alarms that each company had in a stacked or group bar graph and then compare that to their total number of accounts.
I can make each card seperate, but I can't figure out how to combine them both so that it looks like the attached image where the green column shows total number of accounts and the red column shows total number of alarms. This way I can see the percent of accounts had alarms for each dealer.
Any thoughts?