Bar chart limit

[stephenedberkg]

i have 24 months in barchart.

but want to show last 12 months only

how to limit the dimension?

PFA

[stephenedberkg]

same concept but instead of monthyear i want calculate it for weekofYear

[#3]

Plz check this

[t_chetirbok]

try this sum({1<DATE={">=$(=date(max(DATE)-83))<=$(=date(max(DATE)))"}>} VALUE)

[#5]

Hi,

If you are loading from different sources for History and Forecast. Create a flag to identify the data and use the flag in your set analysis expression. So, that the data will be shown for Forecast only.

Ex:

History:

Load *, 'History' as Flag from History;

concatenate

Load *, 'Forecast' as Flag from Forecast;

Hope it helps..