Gauge and last value Problem

[#1]

Hello everyone, I’m trying to find out a solution to this problem:

I have the following fields:

-System (Each element belong to one System)

-Element

-Date (There is a lot of data)

-Value (Engineering value (Positives and negatives values))

What I need to do it creates a Gauge Chart for each System, with show the Value of the last Date.

The limits of the Gauge must be the minimum and the maximum value from the available and possible data (Considering that each element count with different data that’s depend principally in the System)

Hopefully you can find the answer

[christophebrault]

Hi,

Without testing this solution, i can advice this :

create a simple table chart with system and element as a dimension

expression :

only({$<Date={$(=Max(Date))}>}Value) This will show only the value with the max Date for each system and element

choose gauge as representation and set min and max :

min : =Min(Value)

max : =Max(Value)

[jonathandienst]

Hi

Are the guages you need inside a table, in a trellis or individual standalone guages?

Jonathan

[#4]

Hi Jonathan,

There are Individual Standalone Gauges

In moment I try luck with the expresion from cristoph...

Thanks...