Howto: Limit/filter data dimension in a Bar chart?

[#1]

I would like to limit dimension in bar chart (that represent dates) - to show only data representing last month available (from data load date).- is that possible? - I have a field called LoadDate in the dataset with the loaded date represented as YYYY-MM-DD.

[vinay_hg · Accepted solution]

you have to write conditional dimension in dimension i.e.

=if(date(Date,'dd/mm/yyyy')>date(LoadDate,'dd/mm/yyyy'),Date)

it will work!!!..

[#3]

Don't forget to untick "Show null values"

you could also do this with Set Analysis

[#4]

Yep it did work 🙂 thanks !! - now I just have to figure out how to limit on a number of days backward from data loaddate rather than an actual date.... (So i always have last ie. 20 days displayed)

[vinay_hg]

try this

here i consider LoadDate as your dimension.

=if(date(LoadDate,'dd/mm/yyyy')>date(Today(),'dd/mm/yyyy')-20,LoadDate)

or

if u want backdate of field LoadDate and by considering your Date field is Dimension

=if(date(Date,'dd/mm/yyyy')>date(LoadDate,'dd/mm/yyyy')-20,Date)