Project Run Rate

[mparker123]

Hello All,

I created a bar graph and I have this as a Calculated Dimension  =if(Match(MONTH,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')>=Num(Month(Today())),MONTH)

This works but I would like it to start after the first Friday of every month.

We use a time tracking system and we are calculating project run rate. since we enter our time at the end of each week the run rate will show zero until time is entered on this Friday at the end of the week. Because of This we would like the bar chart to still show the last Months run rate until time is entered after the first Friday. I assume i would have to tweak the (TODAY())))) to a different thing.

[swuehl]

Maybe replace Month(Today()) with

Month(Weekstart(Today(),0,4))

[vishsaggi]

May be this?

= if(Match(MONTH,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')>= Num(Month(IF(WeekDay(Today())='Fri', Today()))),MONTH)

[manoj217]

as of my knowledge it will shows the data above of current month

for example: today month is oct data will shows remaining months nov, dec in num format like 11,12 month