I had previously done a “col series stack” chart that was working fine and now it isn’t working anymore. I show a picture to better explain my problem:
As you can see, the x-axis, “Year” is repeating itself from 2015 to 2020 (three times). I believe the 3 times repetition is because I have a Filter in the top of my Dashboard with three categories, so as I click in one of them it disappears the two other and the x-axis is presented correctly from 2015 to 2020 (without repeating).
The problem is that two weeks ago it was working fine (even with the Filter feature), I had a x-axis from 2015-2020 (without repeating) and the values would stack over each bar and when I applied the Filter, it would just disappear some of the bars, but the x-axis (2015 to 2020) would always be static.
What should I do to come back the same behavior of a static x-axis with the criteria/conditions that I just explained?
Briefly, I have data in the following way (approximation, it does not represent the chart):
The “Year” column is repeated 3 times because in the “Account” column we have 3 people, which are the Filter that I previously mentioned and then I have many columns which represent the colored bars in the chart.
I hope someone can help me, I tried to solve already by doing:
- On AppSheet -> Data-> Table, I put column “Year” as Label.
- In the Slice (where I put [Currency]=USD), I changed from “auto” and selected all the columns except “Account” which is the one that I am afraid that is making the repetition, but I didn’t succeed with “col series stack” chart, maybe another type of chart would work.
Anyway, I will keep trying but if anyone could help me I would really appreciate, it’s quite annoying when things change and you have to change as well, but I guess is for the better and smoothness of AppSheet.