Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!!!..
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!!!..
Don't forget to untick "Show null values"
you could also do this with Set Analysis
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)
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)