In DataDog: Let's say my data is a set of price lists of fruits with the name and price:

{
  "fruits" : [
    { name : "apple", "price" : "1.00" },
    { name : "orange", "price" : "0.80" }
  ]
}

I want to make price of apple a column or to be able to get the price of apples as a calculated field #ApplePrice

Is this possible with datadog? The issue I have is that @fruits.name is not a unique value, so I cannot make it a column from the gear widget.

alternative is to use a calculated field, but I don't know how to do a calculated field dependant on another.

any suggestions?