Skipped rows of Cube value of 0

Ilham Maulana Habibie · 2025-05-22T08:08:19+00:00

There was an error rendering this rich post.

Hi guys,

I have some issues that have skipped rows of Cube value of 0 but in Data Reader ETL is displayed well. I have unchecked Hide zeros and checked differentiate zero and null.

Anyone have some ideas or solutions about this one?

Thanks previously

Find more posts tagged with

Cube

Dataview

Data Reader

Accepted answers

Akrem ABDELHAFIDH

Hello @Ilham Maulana Habibie
Thanks for the detailed explanation and for the screenshots and thank you @Helmut Heimann for your valuable insights.

Maybe you can try this in the ETL:
if(C6 = 0, 0.000000000000000000000000000001, C6)
It might prevent Board from skipping zeros when using Double type and no need for show all.

Akrem

All comments

Helmut Heimann

Hi @Ilham Maulana Habibie ,

just to understand better where the issue is: could you please provide a screenshot of the ETL and one of the dataview displaying the values in a wrong manner?

Best,
Helmut

Ilham Maulana Habibie

Hi @Helmut Heimann

Here I attached the captures.

Thanks.

Ilham Maulana Habibie

Hi @Helmut Heimann

FYI : when I changed CUBE_Variable_Rate to Text data type it's not skipped value of 0, but when I reversed it back to Double data type it's skipped value of 0.

Is it normal flow in Board ?

Helmut Heimann

Hi @Ilham Maulana Habibie ,

To see zero values, you might want to tick the box "Show all" in the rows section of the axis.

If you additionally ticked "Differentiate zero and null" in the layout's object settings, zero will be displayed as "0" and NULL as " ".

Best,
Helmut

Ilham Maulana Habibie

Hi @Helmut Heimann

I think it's not suitable option that I want to do, is there anyways to solve it?

Thanks.

Helmut Heimann

Hi @Ilham Maulana Habibie ,

why isn't that an option?
You know that Board will, by default, only show rows where cells have values, right? This can only be overcome with the "Show all" option.

Best,
Helmut

Ilham Maulana Habibie

Hi @Helmut Heimann

Because it will show many of datas that shouldn't be shown, I just want to show the necessary datas from actual user input, so I don't want to use that option. I will be gratefull if there are other any ways to solve this one.

Thanks.

Akrem ABDELHAFIDH

Hello @Ilham Maulana Habibie
Thanks for the detailed explanation and for the screenshots and thank you @Helmut Heimann for your valuable insights.

Maybe you can try this in the ETL:
if(C6 = 0, 0.000000000000000000000000000001, C6)
It might prevent Board from skipping zeros when using Double type and no need for show all.

Akrem

Ilham Maulana Habibie

Hi @Akrem ABDELHAFIDH

It's worked fine for me.

Thanks a lot.

Leone Scaburri

Hi @Ilham Maulana Habibie,

the suggestion from @Akrem ABDELHAFIDH makes sense because when you differentiate ZERO from NULL Board is saving a 1E-30.

When you export your layout, you can also increase the number of digits to 30 to ensure that you can track zero input by your users.

Look at the suggestion from Lorenzo into this thread:

https://community.board.com/discussion/18865/smart-import-should-accept-the-uploading-of-zero

Akrem ABDELHAFIDH

hi @Leone Scaburri
Thanks for sharing Lorenzo’s suggestion, it looks complementary and quite relevant, especially for smart import use cases.