Wave Chart Hide One of Multiple Groups

Question

I have an Opportunity dataset which I group by Account to get the sum of opportunity amounts per account. I want to now show a chart of those accounts grouped by their created date. In essence get totals of accounts opportunity values broken down by when the account was created. The problem is that I don't want the Account grouping to be on the chart. I just want a Column chart where the Y axis is the sum of amounts and the X axis is the account create date. So basically I want two groupings to get the data right, but only want to chart based on the one grouping. We want to do a lot of different filtering on the opportunities , which is why this is based off the opportunity data.

I've looked at different data transforms, compare tables, saql and pigql in the dashboard. Can't figure out the best way to do it.

Thanks.

Ed Ruzol · Accepted Answer

Hi James,

You can join the Wave Analytics group via

https://success.salesforce.com/featuredGroupDetail?id=a1z30000006IDYqAAO#.a0L3000000Rq7JHEAZ to collaborate with other Wave Analytics experts and even post the question in there, you'll also get a response faster this way.

Thanks!

Alberto Minardi · Answer

Hi James,   any chance you figured out how to handle this scenario?   I'm currently facing the same problem.   Thank you

Wave Chart Hide One of Multiple Groups

Ask An Expert

Formation associée

Aide supplémentaire