Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Add Average Line in Gauss Curve

Good Afternoon All,    I am needing some help as I have exhausted everyting I can think of in doing this. I have a Gauss Curve, or "bell curve" I created for information related to how many days di...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

If that is a line chart visualization, there is a built in Average line in the analytics pane in the Visuals area (magnifying glass icon). Also, for you measures, you may be able to change them to the following:

 

(µ) DayDiff = AVERAGE(ALL(OnTimeDelivery[DayDiff]))
(σ) DayDiff = STDEV.S(ALL(OnTimeDelivery[DayDiff]))
 
Then you should be able to add them to the Values area of your visual.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    So the visual is a line and stacked column chart and when I click the Magnify glass it states that analysis can't be done. I also tried the ALL function in the rewritten measures but it kept giving me an error and would not function. If it helps here is kind of more what I am looking for: 

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Sorry, probably:

       

      (µ) DayDiff = AVERAGEX(ALL(OnTimeDelivery),[DayDiff])
      (σ) DayDiff = STDEVX.S(ALL(OnTimeDelivery),[DayDiff])