Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've a Line graph with three KPI metrics, the issue here is some the values are either getting overlapped by the Line itself or by the data value of another expression value.
Please suggest if any work around to solve this.
Please refer to the mock app with screenshot
Jan didn't look right where 398 was lower than 354... changed the expressions to this for the display of numbers
Dual(RangeMin(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty)), sum({$<Year={"$(=max(Year))"}>}SoldQty) * 0.90)
and
Dual(RangeMax(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty)), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty) * 1.1)
I simplified your expression from 3 expressions to 2 expressions. Also, this is not perfect, but my solution is based on these two threads
Stopping values on data points overlapping
So, basically I created two new expressions for displaying the value
Dual(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year))"}>}SoldQty) * 0.90)
Dual(sum({$<Year={"$(=max(Year)-1)"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty) * 1.1)
and both these lines are set with a background color of ARGB(0, 0, 0, 0). Also, removed 'Value on Data Points' for your actual expressions.
Jan didn't look right where 398 was lower than 354... changed the expressions to this for the display of numbers
Dual(RangeMin(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty)), sum({$<Year={"$(=max(Year))"}>}SoldQty) * 0.90)
and
Dual(RangeMax(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty)), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty) * 1.1)