Working with absolute Number instead of percent in Linegauge

[Nocto]

Hey guys,

Hopefully you can help me: So right now I calculated a AVG process time for a hotline with the question mind "in average how long does it take to close a ticket" per Queue in a tablebox.

but independently of the avg i want in the Dimension next to the average the real processtimes "how long does a ticket takes to close" per ticket in a queue in a  linegauge.

With that in Mind the minimum value is zero and the max value is the longest process time.

I want to take on a Line gauge  between zero and lets say 2 days is great and >2  is bad and so on.

How is that to accomplish? Example:

[QFabian]

HI, is this what you are asking for:?

I created a straigth table with one dimension 'Queue' and one expression 'sum(Days)'

1.- select your expression

2.- select linear gauge, and go to their settings

3.- define min and max values

4,. define if you want 2 or 3 segments