Table - Is it possible to change "Max Gauge value" based on some value?

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    v10.0.3

  • What are you trying to achieve?
    I have a table with datas like this:
    “id”,“Component”,“Preset(H)”,“Current(H)”,“Status”
    1,“Motore M1 - Catena”,30000,31000, 2
    2,“FTC M2B4”,15000,10000, 1
    3,“Motore M1 - Ingrassaggio”,10000,50, 0

I have "Current(H) cell type as “Gauge”. i would like to change the “Max” options based on is "Preset(H).
So for the “id” 1 i would like to have “30000” for 2 “15000” and so on
Is it possible to do it?