7 Replies Latest reply: Jul 6, 2017 12:08 PM by Michael Tarallo RSS

    Bar Chart - Value Mismatches

    Prashanth Reddy

      Hi,

       

      I have one bar chart and pivot table for the same data.

       

      I'm trying to prepare generic bar chart and pivot table, for that I have created a list view to select a particular dimension.

       

      Once user select the dimension from the list then the bar chart and pivot table should display data accordingly. For me everything is working fine other than one default case.

       

      List view is consisting of 'Year', 'Quarter', 'Month'

      Bar Chart and Pivot table created with 2 dimensions and one measure.


      1st Dim:

      if(GetSelectedCount(FieldValue) = 0, Month,

          if(GetFieldSelections(FieldValue) = 'Year', RHFisYear,

              if(GetFieldSelections(FieldValue) = 'Quarter', RHQuarter,

                  if(GetFieldSelections(FieldValue) = 'Month', Month)

              )

          )

      )

       

      2nd Dim: if(Team = 'Global Serv Mktg', 'GSM', if(Team = 'Mkt-Ops', 'MO', Team))

       

      Measure: $(vUtilizationHrs)/($(vAvailableHrs))

       

      vAvailableHrs:

      Sum(TOTAL <[Date Entered],Resource, Team, Month, Quarter, RHQuarter>

      Aggr(NetWorkDays (Date#(Min(date([Date Entered],'M/D/YYYY'))),Date#(max(date([Date Entered],'M/D/YYYY')))),

      Resource, Team, RHQuarter, Month, Quarter)*8) -

      sum(TOTAL <[Date Entered],Resource, Team, Month, Quarter, RHQuarter>aggr(sum(if(IsHoliday = 'Y', '1', 0))*8,Resource, Team, RHQuarter, Month, Quarter))

       

      vUtilizationHrs:

      Sum([Utilization (In Hrs)])

       

      Requirement:

      If nothing has selected from list view, by default it should consider 1st dim as Month (Ref above expression) and if something has selected, reports should display accordingly.

       

      Issue:

      By default my bar chart is displaying values (5 times to expected value) but pivot is displaying accurate.

      If i select month or any other list value, then the values are displaying correct.

       

      I don't know why default value (month) showing 5 times than when I select month from list.

       

      By Default:

       

       

      When I select Month:

      Note: Ignore the label name Year, label should be Month.

       

      Can anyone help me in understanding the issue.

       

      Thanks & Regards,

      Prashanth Reddy D.