13 Replies Latest reply on Mar 30, 2020 1:22 PM by Hari Ankem

    Showing YOY change based on filter

    Mike Di



      So I have a workbook that shows the average time it takes to go through a process and the dashboard is filtered by fiscal year. I want to show a comparison of the timeliness metric to the previous fiscal year based on the year chosen in the filter. I created a sample workbook with superstore data. In the sample workbook I show the average ship time by state and the year filter is set to 2018. In this example I need to write a calculated field that will show whether the average ship time is faster than the previous year (2017). The comparison should change based on the year chosen in the year filter. Can anyone help?