Calculated Dimension Help

[samvile18]

Hi Guys,

Can anyone help with the following problem please?

I have a list of week numbers in the following format Week1, Week2, Week3 etc....I'm currently up to week 13.

What I want to do is create a calculated dimension that looks at the latest week only....so in this case it would bring back Week13, everything I've tried just isn't working.

Any help is greatly appreciated.

[pljsoftware]

Hello,

would you like to select only a week? I have not understand your problem. Can you explain it with an if syntax expression?

[samvile18]

Yes...I basically only want to select the latest week of data. I'm trying to create some gauges that only report on the latest weeks worth of data...in this case they would be reporting on week13....whereas next week it would move on to week14 etc.

[pljsoftware]

Hi Sam,

you can create a variable with the value of maxdate and use this variable to take only the products of the last week.

Example:
If your variable is vEndDate and your date field is Date you can write this formula in your gauge chart

if( Date>(vEndDate-7), sum(Qty))

This only if you want to calculate always the value of the last 7 days.

Regards
Luca

[suniljain]

if(WEEK = Max(Week),WEEK)

OR

If want summation of amount

Sum(if(WEEK = Max(Week),Amt))