Bottom 10 by Calculated field excluding Null value

Question & Answer
,
1

Hi,
I have a Bottom 10 bar chart by a calculated field which contains Null value.
I want to get bottom 10 that excluding null value.

But after applying bottom 10 to the filter, the visual showing 10 objects with “Null”
When I apply excluding Null, the visual show “No data”

Is there anyway I can show bottom 10 excluding null values?
P/S: I also tried to create another calculated field that change null value to a very big number to get the bottom 10 but not successful

2

How to attach a file??

3

Hi @baduong
did you try to create a filter to exclude the null values and create the bottom filter?
BR

1 Like
4

2024-01-11_120652
2024-01-11_1206521470×636 120 KB

@ErikG I did (see attachment)

5

I found workaround for this:

  1. Create 1 calculated field named A:
    ifelse(isNull({}),999999999,{})

  2. Add 2 filters to bar chart:
    Filter 1: Bottom 10 by calculated field A
    Filter 2: Calculated field A, less than 999999999

6

@baduong that’s great.
Could you please solve the topic.