Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm still designing my Dashboard.
I have two Options (see attachment gauges):
1) a straight table with mini-gauges built in
2) a straight table plus a trellisbox with gauges
Option 1 saves space but the gauges don't show the right values, the gauges in the trellisbox give the right values.
Both options have the same Dimension and the formula are also the same:
if (Sum(BudgetAmount) > 0, Sum(ActualAmount) /Sum(BudgetAmount), 0)
The settings for the segments are also equal:
Segment 1: startposition 0.0
Segment 2: startposition 1.0
Min value: 0
Max value: 1.2
Hope someone can tell my why in option 1 the gauges have a problem with displaying the right values. And how to solve it (if there is a solution)
Thanks in regards
Court
Please provide a small example which also showed which results do you expect. Beside them you could simplify your expression to: alt(Sum(ActualAmount) /Sum(BudgetAmount), 0).
- Marcus