How to make dynamic min/max dimensions in charts?

[#1]

Hi,

Im trying to make a chart where the dimension (date) is always showing 30 dates back from the maximum date among all possible dates.

I have been trying to solve the problem with SET, like this:

=sum( {$<DateCounter = {"<=$(#=max(DateCounter))"}, DateCounter = {">=$(#=max(DateCounter)-30)"}, Date={"*"}, Year={"*"}, Week={"*"}>} [Fact_ProcessTime] )

..but it is not working, the max date is static, only the min date changes.

Anyone got an idea how to solve my problem?

[#2]

Hi,

You will be able to do this using variable as

set varDate=monthsstart (date(DateCounter), -1 )

Regards!!

Nilupa

[#3]

This is not what im looking for. I want to be able to choose any point/points in time and automaticaly chose the most recent one and generate the data 30 days back from that date(the most recent).

Any other ideas?

Regards/
Hilman

[#4]

Hi,

Check below expression would help you.

=sum({<DateCounter = {">=$(=date(max(DateCounter )-30),'MM-DD-YYYY')"}>} MeasureField)

- Sridhar