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’?
@SohamM95 Whats the datatype of the properties used ?
@ChandanU5252 All are text properties. But the aggregate count will return the Y-axis as integer.
@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
@ChandanU5252 I tried and its the same issue. The values are coming only when the result is >0. When =0, its always Undefined.
@SohamM51
Try using the function as attached here , which check if null to return our own defined value , as in our case it should 0.
@SohamM51
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.
@SohamM51 Hi, I have the same problem as you.Have you solved it? Thank you.
@ArshadPashaMohammed no it doesn’t work, I’ve already tried it
@SohamM51
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’