Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Or you can use set analysis to do this
Dimesnion
[Date_bla]
Expression
Count({<[Date_bla] = {"$(='>=' & Date(Floor(ReloadTime()-2), 'DD/MM/YYYY'))"}>} Customer)