Get Free Trial
Get Free Trial

Empty charts with Infinity values

Answered
Toni Laukka 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

8 answers

Public
Toni Laukka November 11, 2019

Screenshots were not showing up on the first post.

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Toni Laukka 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.
 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Toni Laukka 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.

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Toni Laukka 6 days ago

Were these issues supposed to be fixed on the recent update to 7.2.20?

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 6 days ago

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

Please login or Register to Submit Answer