Hi,
I'm using a perspective XY chart to plot results from query. It is a dataset with date and 5 series (Answer1 to 5). Plotted as stacked barchart. (Not all 5 series are always in use, it's dynamic, in following example just 1 to 3 are in use).
5 series use same y axes. So I've configured all 5 as Answer1. Plot works fine except when Answer1 has less values than the other ones.
Upper plot should show 1 orange answer and 1 green answer stacked. But y ax is configured as orange one, which value is 1, so it does show more than 1 answers.
Do you have any idea on how to configure y axes to show all answers? Maybe configure y axes as "sum of all answers each day" or something like that, this will be a new series in dataset. only used to configure the axes.
thank you,
Edit to add that, when configuring all series to not stack them, only one answer is shown as well, the green one is not displayed. So I don't know the cause why.