Hello community,
I need some help with formatting some views, more specifically the y-axis. Let’s start with the Line chart. There, I want to display prices, that also vary in the currency.
Case 1: I display values between123,45 and 678,90 Euros.
Case 2: I display values between 10.000 and more than 100.000 Euros.
When I select the Step Count, from my understanding, this should show the number of steps between the minimum and the maximum. For example, if I set this value to 5, I should have 5 steps between the min and the max. Howe4ver, this is somehow not the case. Sometimes I have 7, sometimes 4…
If I don’t select the Step Count and select the Step Size (and in this case, for example to 100), my axis should display steps of 100. This is working - but only if my range starts at 0. Now Imagine case 2, with a start of 0. That would mean that there is a lot of “dead” in the line chart, cause my values start at 10.000. If I would start on the other hand with a range based on data, my null will disappear and replaced with the minimum. In combination with a fixed step size(for example 100) my y-axis would be a total mess and hard to read (considering case 1)
My question is now: Is there any way to somehow let the y-axis start at 0, let the scale of the y-axis be set fix based on selected values (e.g. different currencies) with the help of the step size / step count without messing up the scale? Attached, you can find two screenshots of “messed up” scales…
