Graph Display - Suggestions/Comments
Please see attached screenshots. I have risk & opportunity for 2 different groups, FY18 and MS/DS Prediction. Is there a way I can group these differently to show up in the graph the way I want? I know whe have to take out Risk & Opportunity from the X axis because that is what is currently grouping them. But I would like FY18 (Blue bars) for risk & opportunity grouped next to each other, therfore I guess making FY18 and MAS/DAS Prediction as the X axis categories. The negative bars represent the risk and the positive bars represent the opportunity. However, I want the opportunity to be side by side with the risk, not how it currently is (both opportunities side by side). So i'm not sure what I could put as the category, because I can't put type (Which gives me Risk and Opportunity on the x axis) for it won't group them the way I want them to be.
Then I want a third bar for each group, which displays the difference between risk and opportunity, but grouped with it's correct categories (FY18 and MAS/DAS Prediction). Please see Domo3.pdf for drawing of what I would like (Top drawing).
Do I use SQL for this? What's the best approach? Sorry I know this was a terrible explanation of what I want