Forum Discussion
How to remove blank values from a horizontal bar chart
Hello
I´m working on a project about servers and its errors. In my Y axis I see the name of the servers and in X the count of errors, I also organized them using a TOP 10 so I only see the servers with more errors. However, some cells are blank. and I used a horizontal bar chart to display this. My problem is that the highest number of errors don't have a server associated. I need to "hide" that blank bar and still display the other top 10 without it.
Hope someone understands my terrible english and can help me.
I cannot use the actual data so here it is a sample I created with random values
Regards.
You can add the same field to the fitlers a second time! In this screenshot, I've added the rating field twice and you can use it to filter out the blanks and get the top 10
6 Replies
- Syk
Resident Rockstar
You can use a visual level filter to remove the blanks (or nulls).
Just select the visual, find the y-axis value (names of servers) and under basic filtering deselect the blank (or null) value!- Syk
You can add the same field to the fitlers a second time! In this screenshot, I've added the rating field twice and you can use it to filter out the blanks and get the top 10