0 Replies Latest reply: May 20, 2018 8:46 AM by Evgeny Stuchalkin RSS

    Base lines in chart, based on standart deviation

    Evgeny Stuchalkin

      Hi! I want add to my linear chart , that represents sales sum by day, following base lines:

       

      average per day, average per day + 3 standart deviation (upper baseline), average per day - 3 standart deviation (lower baseline).


      Here is my result:


      4c397d7067.jpg

       

      As you can see, upper and lower baselines is -6.93k and 78.83k. All values is in range. But i'm espect to see something like this:

       

      trend03.png

       

      My measure: sum({$<Eantity={"Sales"}, DateType={"Sales_Дата"}, Mode={"STD"}>} [Sales.Sum])

       

      Avg Baseline: avg(aggr(sum({$<Eantity={"Sales"}, DateType={"Sales_Дата"}, Mode={"STD"}>} [Sales.Sum]), Day)

       

      Stdev Formula: stdev(aggr(sum({$<Eantity={"Sales"}, DateType={"Sales_Дата"}, Mode={"STD"}>} [Sales.Sum]), Day)

       

      Day - dimension in main calendar table. Not all Days have Sales.Sum value.


      DateType - field in main calendar, that makes aggregation om concret date type, like:"DealCreate" or "DealClose". remoning that condition from set analysis don't change anything.

       

      Why lower baseline below zero, if there is no negative value in Sales.Sum? May be I need calculate it in another way?

       

      Result, that i want - Excellent Analytics Tip #9: Leverage Statistical Control Limits - Occam's Razor by Avinash Kaushik