6 Replies Latest reply on Oct 19, 2018 9:32 PM by Yuriy Fal

    Month over Month Change using blending

    Angus Ker

      I have a created a month over month change using a blend. It is the same data source with a shifted date on one of them to get the previous months value. It works well on the dashboard, unless there is no value for a certain expense during a month. For example, Bill did not have any food expenses for the month of Feb, so the 'Change' calculation in March is incorrect. Is there a way to capture every change even if the one month doesn't have a value in it? Without any action filters applied, the dashboard works great. Right now I am only trying to get it to work with Month over month, but the end goal is to have a dynamic date selection where you can see changes over months, quarters and years.

       

      Thanks!

       

      workbook is using 2018.1