I am in trouble and struggling with designing an expression which seems to me pretty simple, but in fact, I was able to write it down as expected.
Let me show you the scenario:
So, I have that for each date, I calculate the avg value and calculate a percentage of "improvement" of the value, following this formula: input-output/input*100.
This works fine when I have the Date Dimension (as in the picture). But I want to remove it and calculate an average of the formula (input-output/input*100). I do not want avg(input)-avg(output)/avg(input)*100, but the percentage average.
May you please help me to reach this goal? How can this be done?