8 Replies Latest reply: Apr 29, 2014 10:27 AM by Greg Williams RSS

    Which expression will perform well in chart

    Anosh Nathaniel

      Hi All,

       

      I have two ways to write a expression in Chart. I want to calculate Sum of duration against a study dimension. I am using date dimesion as a data island.

      Which expression will perform well out of the two written below:

      1. sum(if(MonthYear=#MONTH_YEAR,Duration))

      2. sum({<MonthYear={$(=concat(#MONTH_YEAR,','))}>} Duration)

       

      The dimension in chart is StudyId.

      MonthYear column is a number represent a unique number for each month and year. This column is part of Study table.

      #MONTH_YEAR is also a unique number for each month and year. It is part of Calendar table.

       

      Hope I am able to explain my problem clearly.

       

      Thanks & Regards,

      Anosh Nathaniel