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!