12 Replies Latest reply: May 29, 2017 2:02 PM by Dafnis X RSS

    Getcurrentfield in TOTAL expression

    Dafnis X

      Hi,

      My bar chart has 2 dimensions:

      1.periods - cyclic selection

      2. metric code (1-4)

      expressions:

      1.bar - order quantity

      2.text - average duration of all segments for the current period (e.g., date)

       

      I need to display an average for each column, according to a selected cyclic dimension.

      But the following expression doesn't work, as all the values are the same.

       

      sum(TOTAL <$(='[' & GetCurrentField([Cyc_SaleOrd_Periods]) & ']')> Order_OpenTarget_TimeDiff)

      /count(TOTAL <$(='[' & GetCurrentField([Cyc_SaleOrd_Periods]) & ']')>  DISTINCT  SaleOrder_ID)

       

      Would appreciate another way to display it...

       

      Thanks!

       

      bar_chart_total.png

       

      Message was edited by: Dafnis X Attached sample data