How to: Recent seven days by the selected day

[#1]

I need to show last seven days according to the selected day.

how to do it?

Thanks

[Anonymous]

hi

Try like this

Date:

LOAD * INLINE [

    Day, Value

    01/01/2016, 10

    02/01/2016, 20

    03/01/2016, 30

    04/01/2016, 40

    05/01/2016, 50

    06/01/2016, 60

    07/01/2016, 70

    08/01/2016, 80

    09/01/2016, 90

    10/01/2016, 10

];

Add a variable vMaxDate :=Date(Max(Date(Day))-7)  /* MaxDate*/

Sum({<Day={"$(vMaxDate)"}>}Value)

[#3]

Thanks, attached screen shots.

Please check, what i did wrong?

[Kushal_Chawda]

Select the Date you want and make sure that Date field is in proper Date format, use below expression

=sum({<Date ={">=$(=date(max(Date)-6))<=$(=max(Date))"}>}Amount)

[#5]

Hi Kush141087,

thanks for your help.

I did what you are wrote, please see below. what i did wrong?

Thanks

Ariel

[Anonymous]

Add it in the Expression tab

Sum({<Day={"$(vMaxDate)"}>}Value).

[Kushal_Chawda]

What is the Dimension & Expression you are using? If date is dimension then try below expression

=sum(aggr(rangesum(above(total sum({<Date=>}Amount),0,7)),Date))

[#8]

Hi,

This is my data:

TimeSelection:

LOAD * INLINE [

  Period, dayS

  Day, 1

  Week, 7

  Month, 30

  Quarter, 91

  HalfYear, 183

  Year, 365

];

Time:

LOAD * INLINE [

    Day, Value

    01/01/2016, 10

    02/01/2016, 20

    03/01/2016, 30

    04/01/2016, 40

    05/01/2016, 50

    06/01/2016, 60

    07/01/2016, 70

    08/01/2016, 80

    09/01/2016, 90

    10/01/2016, 10

];

I need to create Fit XY. x=value, y= Day.

I want to choose day and Period and i want to see in the graph the day and all the period before the day.

Example:

I want to see week before 09/01/2016:

Thanks

Ariel

[tyagishaila]

select Line chart than

Take Date as dimension

and

=sum({<Day={">=$(=Date(Max(Day)-6))<=$(=Date(Max(Day)))"}>} Money)  as Expression