3 Replies Latest reply: Jun 26, 2015 11:38 AM by Ramon Covarrubias RSS
      • Re: Limit Bar Chart to Data starting from this year
        Ramon Covarrubias

        you can use year start function

        sum({<MonthEnd {">=$(yearstart(max(Date)))"}}Value)

          • Re: Limit Bar Chart to Data starting from this year
            Myles Holland

            Thanks Ramon.

             

            I did attempt this, but I already have a num function which uses avg for several steps within a cycle

             

            =num(

            if(IsNull(avg({$*<CycleType={'Step1'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime)), 0, avg({$*<CycleType={'Step1'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime)) +

             

            if(IsNull(avg({$*<CycleType={'Step2'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime)), 0, avg({$*<CycleType={'Step2'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Milestone.Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime)) +

             

            if(IsNull(avg({$*<CycleType={'Step3'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime)), 0, avg({$*<CycleType={'Step3'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime)) +

             

            if(IsNull(avg({$*<CycleType={'Step4'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime)), 0, avg({$*<CycleType={'Step4'}, [Status]-={'CANCELLED', 'ON HOLD'}, [Flag]={'0'}, [Cycle Status]={'Actual'}>} CycleTime))

            , '#,##0.0')

             

            I'm not sure how I can layer this in.