Sorting graph - sort order

[#1]

Hi,

I have a problem by sorting my graphs.

I have this graph as is shows now - It shows data from 2014-1-10 to 2014-3-21.

However i have data untill now so i want the graph to show example 2014-07-10 to 2014-08-12

So it only shows the newest dates. How can i do so? I have tried to sort my data by date and make a RowNo()

but when i try to sort it reverse the graph so it shows from 2014-08-12 to 2014-07-10 - So its the wrong way.

Can anyone help?

[Anonymous]

Create a variable for the dates and use inside the set analysis

[#3]

How would you do that if the expression was like this? =sum({<Flag={1}>}Price)

[Anonymous]

Try this

=sum({<Date>={$(vDate)},Flag={1}>}>}Price)

[#5]

but it should not be a date but greather than.

[#6 · Accepted solution]

solved in this post:

make a graph show latest dates values