Skip to Content
Former Member
May 12, 2016 at 04:03 AM

Dealing with Null Value in Dimension


I have a table like this.

The database does not have 2016-04-02.

There was no sales on that particular day.

I want the table to look like this:

2016-04-01 200

2016-04-02 0

2016-04-03 150

I tried 1 solutions below.

Format Table->Show Rows with empty dimension values.

But this does not Work 😢

Can anyone please give me ideas how I may overcome this problem?


screenshot.png (10.3 kB)
screenshot2.png (33.0 kB)