make a graph show latest dates values

[#1]

Hi,

I have a graph with data from the 1st january 2014 until now. But when the graph is shown it can only show maybe 15 dates.

The graph show the dates from the 1st jan - How can i do so it shows the data from the newest dates? so it shows july instead?

[tresesco · Accepted solution]

In your chart expression use set analysis something like:

=Sum({<Date={">$(=Max(Date)-15) <=$(=Max(Date))"}>}Amt)

[#3]

can it be done without set analysis?

[#4]

Because your set filters it down to only 15 dates. I dont want it to be filtered. I just want to see the latest dates instead of the first dates.

[tresesco]

What is your logic to decide a date to be one of the latest ?

[jonathandienst]

Hi

So you would like to scroll it to the most recent dates? I don't think that is possible. Your options are to filter the data, aggregate it so that there are fewer data points, sort in reverse order, or allow the user to manually scroll to the end.

With a a filter like tresesco's suggestion, you can select on a date list box to see the 15 days prior to the selected date (or the maximum date in your model if nothing is selected).

HTH

Jonathan

[#7]

last or first sorted? Due to the fact i dont want to see old data when i first see my grtaph. If i wanna see old data i want to filter it instead.

[#8]

Let me show you a picture.

[#9]

This is how it is now:

This is how i want it

[tresesco]

You may allow user to choose if they want to see old data. By default it would be the latest dates. For that you can use two expressions (one as shown above, another without that set filter) and enable them as per user selection. Allow users to select a flag in inputbox that get stored in a variable.