2 Replies Latest reply on Feb 8, 2016 1:57 PM by pavitra k

    How to build stacked bars

    pavitra k

      I am trying to create stacked bar with total at the top of each architect ex : amit: 0+9 = 9 and Barb is 2+9+7=18 etc.,

       

      i need to show a band using reference lines who is highly occupied ex: 0 to 10 is available and 10 to 20 range = partial >20 is unavailable

      stacked bar.PNG

       

      complexity count calc field is below

      IF [Complexity]='Low'       and [Participation]='Attend'    then 1

      ELSEIF [Complexity]='Low'       and [Participation]='Assist'    then 4

      ELSEIF [Complexity]='Low'       and [Participation]='Drive'     then 7

      ELSEIF [Complexity]='Medium'    and [Participation]='Attend'    then 2

      ELSEIF [Complexity]='Medium'    and [Participation]='Assist'    then 5

      ELSEIF [Complexity]='Medium'    and [Participation]='Drive'     then 8

      ELSEIF [Complexity]='High'      and [Participation]='Attend'    then 3

      ELSEIF [Complexity]='High'      and [Participation]='Assist'    then 6

      ELSEIF [Complexity]='High'      and [Participation]='Drive'     then 9

      ELse 0

      END

       

      Data

          

      numberSolution ArchitectComplexityparticipationStart Date
      2201AmitLowAssit11/1/2014
      2202MurrayMediumAttend1/2/2015
      2203BarbHighDrive10/10/2014
      2204DavidLowAssit3/3/2015
      2205DonnaMediumAttend16/4/2015
      2206ireneHighDrive7/7/2015
      2207JulieLowDrive9/2/2014
      2208KalyanaMediumAttend14/5/2014
      2209LimHighAssit12/12/2015
      2210SourceLowAttend12/11/2014
      2211MickeMediumDrive1/1/2016
      2212MikeHighAssit2/2/2016
      2213MuraliLowAssit10/1/2016
      2214GargMediumAttend11/10/2014
      2215RowsonHighDrive2/3/2015
      2216RaghuLowAssit7/10/2014
      2217RaviMediumAttend6/6/2015
      2218AmitHighDrive3/12/2014
      2219MurrayLowDrive13/2/2016
      2220BarbMediumAttend11/11/2015
      2221DavidHighAssit12/12/2014
      2222DonnaLowAttend14/9/2015
      2223ireneMediumDrive16/10/2015
      2224JulieHighAssit11/11/2014
      2225KalyanaLowAssit10/2/2015
      2226LimMediumAttend12/12/2014
      2227SourceMediumAttend11/1/2014
      2228MickeHighDrive12/31/2015
      2228MikeLowDrive1/2/2015
      2229MuraliHighDrive11/12/2015
      2230GargLowAssit3/3/2015
      2231RowsonMediumAttend16/4/2015
      2232RaghuHighDrive7/7/2014
      2233RaviLowDrive9/2/2014
      2233MurrayLowDrive3/3/2015
      2233BarbLowDrive9/2/2014
      2234DavidMediumAttend14/5/2014
      2235DonnaHighAssit12/12/2015
      2236ireneLowAttend12/11/2014
      2235JulieLowAttend12/11/2014
      2237KalyanaMediumDrive1/1/2016
      2238LimHighAssit2/2/2016
      2239SourceLowAssit10/1/2016
      2240MickeMediumAttend11/10/2014
      2241MikeHighDrive2/3/2015
      2242MuraliLowAssit7/10/2014
      2243GargMediumAttend6/6/2015
      2244RowsonHighDrive3/12/2014
      2245RaghuLowDrive13/2/2016
      2246RaviMediumAttend11/11/2015
      2247MurrayHighAssit12/12/2014
      2248BarbLowAttend14/9/2015
      2249DavidMediumDrive16/10/2015
      2250DonnaHighAssit11/11/2014
      2251ireneLowAssit10/2/2015
      2252JulieMediumAttend12/12/2014