How to set chart dimension to range of two weeks

[#1]

Hi,

I have a chart with a date field as the dimension. I want the range always be from the date of today until 2 weeks back.

How can I achieve this?

[alexandros17]

Write as dimension:

If(Num(MyDate) <= Num(Today()) and Num(MyDate) >= Num(Today()-14), MyDate, null())

let me know

[Anonymous]

Hi,

You can set the range from chart properties Axes tab.

Min = Date(WeekStart(Today())-14)

Max = Today()

[#4]

In the chart, the dimension is shown as numbers and not as dates.

[#5]

HI Nazeem

use floor function to convert number to date

regards

padma

[jonathandienst]

Amend that dimension:

=Date(If(Num(MyDate) <= Num(Today()) and Num(MyDate) >= Num(Today()-14), MyDate, null()))

[alexandros17]

so write simply:

If(Num(MyDate) <= Num(Today()) and Num(MyDate) >= Num(Today()-14), Date(MyDate), null())

[jagan · Accepted solution]

Hi Nazeem,

Instead of doing in dimension you can try the same in Expression, Calculated Dimension will have performance issues.

=Sum({<MyDate ={'>=$(=Date(Today()-14))<=$(=Today())'}>} MeasureName)

This is a good practice instead of doing it in Dimension.

Regards,

Jagan.

[#9]

Thank you!