How do you show the last 12 values on the Demension limits tab?

[#1]

On a line Chart Properties Demension Limits I need to show only the last 12 values out of a list of 36 values. The only options are First, Largest,and Smallest.

Does anyone have any suggestions?

[#2]

The options are based on the sort order. If you want to have the last 12 values (assuming the sort is based on an expression) reverse the sort order and fix to first 12 values. Just play around with sort order and the limit options.

If you could not figure out, scramble and share your qvw.

Regards,

Kiran Rokkam.

[#3]

I do not understand why the option to select “Last” wasn’t included in the list. I need to select the last 12 dates with the oldest date to the left. Any help will be appreciated.

Dave Benzenhafer

[MayilVahanan]

Hi,

     Please see the attached file.

Hope it helps

[#5]

I need the latest date to be to the right of the graph.

Dave Benzenhafer

[swuehl · Accepted solution]

Maybe like attached?

Try using a calculated dimension:

=aggr(if(rank(Date) <=12,Date),Date)