topic Re: Howto: Limit/filter data dimension in a Bar chart? in App Development

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

Fri, 15 Jan 2016 09:30:59 GMT

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.

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

vinay_hg — Fri, 15 Jan 2016 11:58:09 GMT

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!!!..

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

Fri, 15 Jan 2016 12:13:05 GMT

Don't forget to untick "Show null values"

you could also do this with Set Analysis

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

Fri, 15 Jan 2016 12:54:39 GMT

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)

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

vinay_hg — Mon, 18 Jan 2016 05:18:44 GMT

try this

here i consider LoadDate as your dimension.

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

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)