3 Replies Latest reply: Apr 21, 2017 7:11 AM by Allu Allu RSS

    Combine 2 bell graphs into 1

    Yu Jo Kim

      Hi, I am trying to compare 2 normalised distribution graphs for 2 different years (2015 and 2016). Currently, I have to create 2 seperate graphs for each year, however i would like them to be in 1 graph only. How do I combine both graphs together into one?

       

      Currently I am coding it as:

      Dimension : =Round(GBP, BinWidth)

      1st expression : =Count({<YEAR ={"2015"}>}GBP)

      2nd expression : =Only({<YEAR={"2015"}>}NORMDIST(Round(GBP, BinWidth),Avg(total GBP),Stdev(total GBP),0)*BinWidth*Count(total GBP))

       

      for the specific year for 2015, and the same code is used for the graph for year 2016.

       

      Is there a way to code such that both graphs are combined into one, so that comparisons between the 2 years can be more visual?

      Thank you!

       

      Attached images for the 2 different years.