Grouped and Stacked Card with 4 Data Fields
Hi all,
I'm trying to build a group and stacked graph with 4 different data fields and was hoping someone could help me figure out if it's possible.
I have a dataset that looks like the following:
I want to show, by date, the Survey Count by Name in one column next to the Tour Count by name in another column.
Below, I drew out what I am envisioning, based on the data table above:
I'd appreciate any help in determining whether or not this is possible and, if it is, how I can achieve this.
Thanks!
Comments


Not quite. I want tours next to surveys, so each "name" should appear in each column. One column for the number of tours for all three people, next to a column showing the number of surveys for all three people.
You can see the graph I hand drew in my original post to see how I expect the graph to look once completed.
0 
I'm not 100% sure how to go about it given the data structure. Take a look at this link which goes into depth about grouped and stacked bar charts. They have some pretty good insights actually.
From what I've seen, I don't think the first column in each series can be stacked on itself.
1 
I agree with @dthierjung
You will need to make some changes to your data structure.
Try getting to a more "flat" data set that looks more like this:
You can then use a beast mode to calculate the different values you are looking for. Here is the beast mode that I used for Tom  Survey Count:
And here is the "Grouped and Stacked" bar graph:
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman
______________________________________________________________________________________________2
Categories
 10.6K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 63 Kowaza
 296 仲間に相談
 649 ひらめき共有