I am new to Grafana. I am creating a table panel in a dashboard from prometheus data. This table has a calculated percentage field which at times may be > 100% (i.e., calculated percentage may be 110%, 500%, etc). This is a valid calculation for this metric, however, when this occurs, the percentage should display as 100% in the table.

How can I do this?

hello please go to the begginers tutorial, everything is described there.

thanks

habib

Iâ€™ve reviewed the beginnerâ€™s tutorial and, indeed, what Iâ€™ve built so far incorporates much of what Iâ€™ve learned in it, as well as going farther than the tutorial. The `max`

and other function examples in the tutorial appear to assume that I am taking the max of a series. What I am attempting to do is do the equivalent of an â€śAdd field from calculationâ€ť transform, with â€śBinaryâ€ť operation mode. In Microsoft Excel, this would be expressed as:

```
MIN(<calculated_field_name>, 100)
```

And yes, Iâ€™m aware that the Excel `MIN()`

function can take more than two values, itâ€™s just the easiest way I know to express what Iâ€™m doing.

Unless Iâ€™m totally misunderstanding the exercises or missing something obvious, the beginnersâ€™ tutorial doesnâ€™t appear to cover this or an analogous situation.

I did what **should** have been obvious from the start, and added the following Value Mapping field override: