asked on November 11, 2019
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
⋅ November 11, 2019
Screenshots were not showing up on the first post.
⋅ November 11, 2019
Hello, Toni,
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.
Best Regards,
Illia
⋅ November 19, 2019
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.
⋅ November 20, 2019
Hello, Toni,
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:
"measures": [
{
"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.
Best Regards,
Illia
⋅ November 26, 2019
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.
⋅ November 27, 2019
Hello, Toni,
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.
Regards,
Illia
⋅ December 3, 2019
Were these issues supposed to be fixed on the recent update to 7.2.20?
⋅ December 3, 2019
Hello, Toni,
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.
Regards,
Illia
⋅ December 31, 2019
Hi Toni,
We are glad to announce that the issue with inconsistency between column and line charts was fixed.
This is available in the 2.7.22 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if everything works fine.
Looking forward to hearing from you.
Best regards,
Mykhailo
