Forum Discussion

kjartank's avatar
kjartank
Icon for Helper II rankHelper II
9 years ago
Solved

Breaking down values in a line chart

Hi   I'm trying to make a line chart with 4 lines, but with using only 3 variables.   The first line is simple, as the value is the average of a variable and the axis is date. The remaining thre...
  • kjartank's avatar
    kjartank
    9 years ago

    Hi v-ljerr-msft

     

    I think I have found a solution, although it may not be the optimal one. But it works. I've made three conditional columns. So "If Check-in Method = Self service  Then ValueFromMeanCheckIn" This gives me the values that I'm looking for.

spuder's avatar
spuder
Icon for Resolver IV rankResolver IV
9 years ago

Hi,

 

could you show us some example data. In that way it is hard to understand.

 

My first thought is just to make the Averages of those 3 (part) Measures and calculate them strictly mathematically.

 

=(AVG(Values1) + AVG(Values2) + AVG(Values3))/3