Set Axis Scales and Filtering Non-Existent Values in Line Chart Reports

Get Help
1

Hi,

I’m trying to set up a report with line chart that tracks exchange rates, as you can see here:

2024-11-29 at 12.14
2024-11-29 at 12.14998×668 28.9 KB

I’m facing two challenges:

  1. While I’ve filtered the records, where there is no value, the red line still is being displayed as zero. Instead, there should be no line, where there are no values.
  2. In this case the rate is around 80 and as there is no way to set the scale on the y-axis, any fluctuation is really hard to see. Is there any way to set the min/max values for the y axis? Ideally, I’d want to set them dynamic like (min value-10% and max value +10% or similar).

I didn’t find anything in the Reports Help Docs.

Thanks!

1 Like
2

+1
I would also like to be able to do this.

3

+1
I need this too

4

Is this still not posible?

5

+1 would be great

The hack is to use an Annotation to scale the y-axis. You can set the line colour to white FFFFFF and use fixed values or formulas so you should be able to find a way

Also for the “display nothing” this same problem happens with Excel graphs. The hack is to make the values “N/A” instead of 0 so there will be no visible line (rather than a line at 0). I guess because that’s text that can’t be rendered on a numeric axis? I haven’t tried in Fibery but maybe that will work?