Displaying Revenue for Multiple Revenue fields on an Opportunity from Salesforce in the same Card
I'm trying to build a card in Domo to display revenue from different products on an opportunity in Salesforce. What I've done so far is I've got different rollup fields in SF that display the revenue based on these different products on the opportunity. There's 3 specifically I'm worried about. They're all currency fields. What I'm wanting to see in Domo is a stacked bar chart that shows me the amount of revenue in a quarter that's segmented by these three different revenue fields. The X Axis is the owner of the opportunity. So above each opportunity owner I want to see a bar that's segmented into these three different revenue types. What I've tried is I created a field that sums the revenue from all three, put that in the Y Axis, and I input the revenue amounts for each revenue type into the series. When I do this though it stacks the total amount for all three on top of the different segments - which obviously doesn't work because it's essentially doubling everything. I'm pretty new to domo so I'm pretty sure I'm missing something here. Any suggestions about what else I should do?