Forum Discussion

Ben83's avatar
Ben83
Advocate IV
10 years ago
Solved

Trend calculation

I hope you can help me to find a solution for my problem. I want to visualize the trend of my companies delivery reliability (OTIF - on time in full). I have a table which contains every single deliv...
Need Help
  • kcantor's avatar
    kcantor
    10 years ago

     

    I did something similar in our data to show a moving averege of quantiy sold over the past three months. I followed the advice on the following blog in order to capture and quantify the appropriate averages.

     

    http://www.powerpivotpro.com/2013/07/moving-averages-sums-etc/

     

    It was very easy to follow along with this particular blog.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Well, you will need a measure to calculate delivery reliability. Sounds like you already have that. Then, you will probably want a date/time table, something like DateStream from the Azure Data Marketplace (free). Relate your table with your delivery dates to your date table. Then, you should be able to create a line chart, picking "Week of Year" essentially from the date table and your reliability measure and wahla, you should have your trend as the visualization will context filter your measure by the related week of the year.