Dimension limits

[#1]

Hi;

I have a bar graph. My dimension is week number and my expression is avg(LoadingDuration). I now want my bar graph to only show avg(LoadingDuration) for past 3 weeks only and not to show avg(LoadingDuration) for all the week.

How do l limit my dimensions to past 3 weeks average loading durations?

Regards;

Moses

[dinuwanbr]

Hi,

you can use Dimension Limits to limit the dimension.

BR,

Dinu1

[#3]

How do l use dimension limits to limit the dimension to only show the last 3 weeks data?

[#4]

you can add calculated dimension for eg..

if(weekstart(Today(1))-weekno<21,weekno)

where weekno is your dimension

[#5 · Accepted solution]

Hi, maybe you can try this:

First go to dimension limits tab and check the box which restricts the values and select First 3.

Go to Sort tab: Select State descending and Numeric value descending.

Suppose we are in the tenth week, you will get values 10 9 and 8 on your x axis.

Regards,

Pratik

[HirisH_V7]

Hi,

You can use expression like this,

Last 3 Weeks:

Avg({<Date={‘>=$(=WeekStart(Today(), -2))<=$(=Today())’}>} Loading Duration )

Hope this helps ,

Hirish