1 of 1 people found this helpful
Hi Tina, for your first question, are you trying to find the average across months of the same year? Can you just use a plain WINDOW_AVG(SUM([Days/K])) and then set it to Compute using the Year? So something like this...
and then set it to Compute by Year? If you put Year in the view as shown below, you can choose Compute Using > Pane Across on the window_avg.
If you don't want to show the Year in the chart, you can drag it down to the Detail card in the Window_Avg marks card:
For your second question, I'm not sure what you mean by subtracting 10% at 2018.