Forum Discussion

masplin's avatar
masplin
Impactful Individual
6 years ago
Solved

Relative Change Graphic

Hi

 

Does anyone know if a grpahic like this already exisits or i need to write my own measures?  I had a dig through the market place, but didn't find one and yet it is a very common style.  Essentially you are just scaling all values on the graph so the value at the first data point is either 0 or 100. This rescales as you change the X axis.  If you have multiple measures with significantly different vlaues this helps to see thme in a single visual without the small vlaues all beingf compressed at  the bottom. 

 

Thnaks for anyrone woh can save me a lot of work

 

Mike

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    Here's a measure that you can use with a regular line chart:

     

    diff = 
var th = sum(data[Net])
var first = calculate(sum(data[Net]),TOPN(1,allselected(data),data[Snapshot],ASC))
return th-first

     

    Where data[Net] is the monetary value and data[Snapshot] is the datetime stamp.

     

    Using ALLSELECTED will use the first visible "row" as the base value that all other visible "rows"  are compared to. 

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    yes, you may need to create your own measure. Shouldn't be too complicated. Find the first item in your ALLSELECTED collection (for example via FIRSTDATE) and then compare all subsequent items against it.