Bar chart showing undefined instead of 0
When there are zero values for an aggregate column in a bar chart, the value shown is 'undefined' instead of 0 when the mouse is hovered over the bar. Is there any way to display 0 instead of 'undefined'?
***Edited by Moderator Marije to add Enhancement Request FDBK-85270***
Accepted Solution
Updated: 19 Aug 2022 7:22 EDT
Pegasystems Inc.
GB
I have identified your issue as a known limitation in the product.
When there are zero values for an aggregate column in a bar chart, the value shown is 'undefined' instead of 0 when the mouse is hovered over the bar
It is designed to work that way.
An enhancement request already exists: FDBK-85270 (Bar chart showing undefined instead of 0)
Please contact your Account Administrator if you wish to discuss that enhancement in more detail. Current status is still 'Open'
Updated: 28 Jan 2022 7:49 EST
Maantic Inc
IN
@ChandanU5252 All are text properties. But the aggregate count will return the Y-axis as integer.
Mphasis
IN
@SohamM95 Can you try with integer, as its a aggregate column (SUM, COUNT, FIRST, MIN, MAX, etc.) For testing use any integer type will get rid of Undefined
Maantic Inc
IN
@ChandanU5252 I tried and its the same issue. The values are coming only when the result is >0. When =0, its always Undefined.
Aaseya IT services Pvt Ltd
SA
Try using the function as attached here , which check if null to return our own defined value , as in our case it should 0.
Updated: 31 Jan 2022 2:57 EST
Maantic Inc
IN
@ArshadPashaMohammed no it doesn't work, I've already tried it
Aaseya IT services Pvt Ltd
SA
You can trace to check what kind of value you are getting in the field and create the function which can be used in the report definition and transform the value you need.
Accepted Solution
Updated: 19 Aug 2022 7:22 EDT
Pegasystems Inc.
GB
I have identified your issue as a known limitation in the product.
When there are zero values for an aggregate column in a bar chart, the value shown is 'undefined' instead of 0 when the mouse is hovered over the bar
It is designed to work that way.
An enhancement request already exists: FDBK-85270 (Bar chart showing undefined instead of 0)
Please contact your Account Administrator if you wish to discuss that enhancement in more detail. Current status is still 'Open'