After an update to 7.2.16 (includes versions 2.7.17 and 2.7.18) our charts with Infinity values are totally empty.
First screenshot is from the grid. Second is chart with 2.7.15 and last with 2.7.18
Screenshots were not showing up on the first post.
Thank you for reporting about that issue.
The described bug is a known problem and we’re currently working on it.
We are glad to inform you that the fix will be released with ETA Nov 18.
Feel free to contact us in case of additional questions.
The update did not fully fix the issues. It now shows the months with values, but misses the empty months and right side border. It should look like the column line chart, without the line of course.
Thank you for your feedback.
Infinity (division by zero) values are considered undefined, so the pivot does not display them.
Our team would like to suggest a workaround for your case, based on setting a condition to the formula of your calculated value.
The main idea is detecting if a division is going to be done by zero and preventing it, setting the calculated value to zero.
We kindly recommend investigating the code below:
"uniqueName": "Calculated value",
"formula": "if(sum(\"Divider\") != 0, sum(\"Dividend\") / sum(\"Divider\") , 0)",
"caption": "Calculated value"
Also, please, check an example we made for you.
We sure hope it helps.
You are welcome to contact us in case of additional questions.
The workaround is not a valid solution for us. We can’t expect our end users to know how to do this. And as you can see from my previous two screeshots it shows OK if you select the column line graph. This problem only occurs with column and bar graphs. So the behaviour is not consistent.
We would like to kindly notice that the column line type of chart displays two values. The second value that differs from infinity is a reason fields with infinity values are displayed. Details can be found in attachments.
But while investigating your request, we have found another inconsistency between column and line charts that you can see in the attached screenshots.
The fix is going to be provided with the minor update ETA Dec 30.
After the update, calculated measures with infinity values will be displayed on every chart.
Please, contact us in case of additional questions.
Were these issues supposed to be fixed on the recent update to 7.2.20?
Thank you for writing to us.
The fix is going to be provided with the minor update ETA 30 Dec.
Every change provided with the update can be found on the Release notes page.
You are welcome to contact us in case further questions arise.