I need to do the following calculate the diff in hrs for each date with respect to the previous date so that when user selects Date 1/14/2011 from a multiselector, the calculated value for diff should be (Hrs for 1/14/2011) - (Hrs for 1/7/2011) and when 1/7/2011 is selected from a multibox, the calculated value for diff should be (Hrs for 1/7/2011) -(Hrs for 1/1/2011)
All things are possible through set analysis 🙂 First, I would suggest adding an index to your script, similar to what you've done with "Week." Just make sure you actually link it to the data--rename TDate to Date. Then create a variable called vMaxWeek which you would define as follows: =max(Week)-1
Then this code should work for your expression: sum(hrs) - sum({<Date=,Week={'$(vMaxWeek)'}>}hrs)
Note that this won't work within a chart since set analysis is calculated once for an entire chart and ignores dimensions. Meaning, you can't create a chart with Date as a dimension and use the above expression. If you need to do that, you can always use the above() function.
All things are possible through set analysis 🙂 First, I would suggest adding an index to your script, similar to what you've done with "Week." Just make sure you actually link it to the data--rename TDate to Date. Then create a variable called vMaxWeek which you would define as follows: =max(Week)-1
Then this code should work for your expression: sum(hrs) - sum({<Date=,Week={'$(vMaxWeek)'}>}hrs)
Note that this won't work within a chart since set analysis is calculated once for an entire chart and ignores dimensions. Meaning, you can't create a chart with Date as a dimension and use the above expression. If you need to do that, you can always use the above() function.
