Null values in dimension

[#1]

Hi everyone,

Here is a sample of my data:

Date_bla      customers

12/10/2016       5

11/10/2016       2

10/10/2016       3

09/10/2016       1

I want a table that dispays only the last 2 days like this:

Date_bla      customers

12/10/2016       5

11/10/2016       2

So I create a calculted dimension :  =if([Date_bla] >= Floor(ReloadTime())-2, [Date_bla] )

The table I get is:

Date_bla      customers

12/10/2016       5

11/10/2016       2

      -                  4

I don't want te last line to be displayed ! I tried to add the condition on date in the expression as well (even if according to me, I shouldn't need it) : =if([Date_bla] >= Floor(ReloadTime())-2, sum(customers))

but then I still get a line with null values ...

Date_bla      customers

12/10/2016       5

11/10/2016       2

      -                  -

What's wrong ?

In the loaded data, all the "customers" have a Date_bla, so I don't get why null values appear...

Thanks for your help.

Have a good day

Laura

[sunny_talwar]

I think you just need to select 'Suppress When Value Is Null' on the dimensions tab of your chart properties for your calculated dimension for the null value to go away.

[sunny_talwar]

Or you can use set analysis to do this

Dimesnion

[Date_bla]

Expression

Count({<[Date_bla] = {"$(='>=' & Date(Floor(ReloadTime()-2), 'DD/MM/YYYY'))"}>} Customer)