Forum Discussion
Stacked Bar/Line chart not displaying or summarizing properly
Hi dedelman_clng , Thank you for the suggestion.
I have tried the secondary axis, however it does not change the summarization which appears to be the problem. I turned the secondary axis on in the example posted previously, and while the data now overlaps, the straight line in the right visual should look like the line in the left visual.
Community ChampionIt looks like you're trying to graph 2 sets of data (Flow, unstacked_demand) that don't have a relationship with each other. The data model in your example report is very confusing because it is many-to-many relationships all around.
What you should be aiming for is having a Date table, and then creating a relationship with those data tables with dates (Flow, unstacked_demand). You can then use the date column in your Date table as the axis, and you'll be able to associate Flow and unstacked_demand together. Right now, Flow doesn't know about unstacked_demand's date column, nor vice versa.
One other thing to note is that one set of data seems to be continuous (Flow; value every day) while the other is categorical (unstacked_demand; one value per month). Those may not play well together on one graph, as either the monthly data will appear as very tiny line, or the daily data will show as a the value on the same day as the monthly data. The latter behavior is shown below (once I removed some model relationships to allow unranked_demand to be linked to the date table):
Let us know some more information on what the data is and why the relationship are how they are and we may be able to point you further in the right direction.
Hope this helps
David
Thank you for the review and assessment. I will have to go back and build this one differntly i think. I had tried to link the dates, but some other relationship was preventing that. Perhaps having the maps and other data was making this more complicated than i am really ready for. I have daily demands and will see if that works better in a simpler model.
- dedelman_clng
Good luck! Feel free to reach out for further assistance if needed.