Let's say I have 10 companies that have signed up to my service, and then dropped off. I want to figure out how many of these companies are hitting milestones of usage in my system, so I want a bar chart that shows the data. For instance, I have 2 boolean fields on the companies, "Added Card Details" and "Logged in 3 times".
How do I create a bar chart which shows 2 bars, the % of companies which have that value set to "true", as the example below?
I'm pulling the data from BigQuery, but here's an example table of data to create the graph from:
| Name | Added Card Details | Logged in 3 times |
|---|---|---|
| Com1 | true | true |
| Com2 | true | true |
| Com3 | false | true |
| Com4 | false | true |
| Com5 | false | false |
| Com6 | false | false |
| Com7 | false | false |
| Com8 | false | false |
| Com9 | false | false |
| Com10 | false | false |
Should produce a graph which looks like:
Here's a sheet with example data and an example graph:
https://docs.google.com/spreadsheets/d/12jt1ZlhJ-5Hc8XtQsyXVVnLC1F6GOZz9euZkN2y1jNw/edit?usp=sharing
Here's my attempt at creating the graph. Not sure where to go from here when Dimension has to be declared and only allows one option.
https://datastudio.google.com/reporting/f9a2db1c-2c32-41b6-8e47-1848e2577417
