0 Replies Latest reply: Nov 23, 2016 7:52 AM by PAUL YEO RSS

    My 8020 chart take long time to load , Any way to simplify the expression ? so it can load faster.

    PAUL YEO

       

      Hi All

       

       

      I have below diamension :-

       

       

      =$(ColumnDim_p)

       

       

      =if(aggr(sum(sales),$(ColumnDim101)) / aggr(sum(total <$(ColumnDim_p)> sales), $(ColumnDim101)) > 0.001, $(ColumnDim101), 'OTHERS')

       

       

      I have below expression :-

       

       

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      $(ColumnDim51)/$(Columndim89))

      /

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      TOTAL <$(ColumnDim_p)

      > $(ColumnDim51)/$(Columndim89))

       

       

      Above chart work fine , But it take long time to create the chart.

       

       

      Hope some one can advise me where go wrong ? I mean how to simplify the above syntax , so that the chart can load faster.

       

       

      Paul