How to get a chart show 10 days before today's date?

[zenobendi]

Hi,

I have a chart and I want it to show the data only for 10 days before today'date. So if today is the 02/18/2019, I want it to show the data for:

02/18/2019 , 02/17/2019 , 02/16/2019 , 02/15/2019 , 02/14/2019 ... until ... 02/09/2019

Is there any calculated dimension I could use?

Thanks

[ali_hijazi · Accepted solution]

if the field is called Date then create a chart with Date as dimension 

then in the expression your set analysis should contain something like this:
{<Date={">= today-10 <= today"}>}

usually I transform dates into numbers so in the script the field Date would be coming as num(DayStart(Date))) as Date

so expression would look like

sum({<Date={">= $(=num(addDays(Today(),-10)) <= $(=num(DayStart(Today()))"}>measure)

[agigliotti]

let's try with this calculated dimension:

Aggr( if( today()-dateField <= 10, dateField ), dateField )

and tick "Suppress When Value Is Null"

[MindaugasBacius]

It depends as always 🙂
If you have the sheet that only contains 10 days data than you can add Trigger in the sheet properties.
If you wish to have Chart table with only 10 days, then you need to use Set Analysis in all of your expressions like:
Count(Count({<Data = {">$(=Date(Today() - 10))"}>} Data))