Remove values from bottom axis

Dashboard Designer
1

My bottom axis shows 0’s with the value name as well resulting in overlap and making the chart hard to read
can you help me remove the bottom data?
image

2

I realized that this is values for an undefined tag, by deselecting that option, most of the zeros dissapear

3

So new question, how can I keep the undefined from showing in my data?
image

4

Dear Turtlgal,
This really depends on your list and chart configuration, although, that is definitely possible. Can you send us a screenshot of the list that you work with and some screenshots of the chart configuration? Then we could recommend a solution.

5

image
image.png885×597 31.2 KB

image
image.png960×676 16.9 KB

image
image.png703×617 8.1 KB

image
image.png978×561 5.08 KB

image
image.png621×858 9.94 KB

6

Dear Turtlgal,
Thank you for the screenshots! I believe that you should be able to replace handlers.aggregationSuccess in the Data Source -> Advanced tab with the following code:

handlers.aggregationSuccess = function(data, logger) {
  for(var i = 0; i < data.groups.length; i++){
    if (!data.groups[i].value){
      data.groups.splice(i, 1);
    }
  }
  return true;
}

I hope that this will remove all null values from the chart. Let me know how it goes, if it helps or not!

1 Like
7

That worked! Thank you