Chart with series of different precision
Posted: Tue Jun 03, 2025 3:30 pm
Hello,
I'm trying to make a chart with 2 series of values with different precision.
The first one is a standard line with 10 values of intervals from 0 to 1 step 0.1
The second one is a stepped line which must intersect the first serie at a specific value, the range is the same, 0 to 1 but the step is 0.01.
The only way I managed to do it is by abusing of null values on the first serie so there are the same number of values.
Problems:
1) I can't set the series to "connect points with line" on the nulls, it seem to convert the nulls to 0 even if the "convert nulls" option is disabled on the report.
2) The chart prints a lot of unwanted grid lines, I need to print only the steps of 0.1
I made an Excel mockup of what I need:
Attached the report and the CSV
I'm trying to make a chart with 2 series of values with different precision.
The first one is a standard line with 10 values of intervals from 0 to 1 step 0.1
The second one is a stepped line which must intersect the first serie at a specific value, the range is the same, 0 to 1 but the step is 0.01.
The only way I managed to do it is by abusing of null values on the first serie so there are the same number of values.
Problems:
1) I can't set the series to "connect points with line" on the nulls, it seem to convert the nulls to 0 even if the "convert nulls" option is disabled on the report.
2) The chart prints a lot of unwanted grid lines, I need to print only the steps of 0.1
I made an Excel mockup of what I need:
- Screenshot 2025-05-30 155806.png (91.1 KiB) Viewed 1197 times