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]

Sort on Date -> Descending order and enable scroll in the presentaion tab.

[#3]

scroll is not an option. Looks bad!

Sorting will make the dates turn wrong.

But i guess its not possible - I would have to make set analysis that dont disregard the selections

[#4]

perhaps something like this:

Try to sort with formular:

firstsortedvalue(Amt, -[YourReloadDate])

The"-" before your reload timestamp kind of makes the opposite. So Lastsortedvalue ISO firstsortedvalue...

Maybe you can work around this one?!

Why is sorting turning your dates wrong???

Anthony

[#5]

Hi thank you for this.

But when i type this set analysis in - Then i cannot use my filter . Eg months. Because then it will only show 15 days in that month.

How do i make it account for my selections?