In this panel, I want to remove the decimal precision in the single value while keeping it in the trending value.
How can I do this?
Try adding | fieldformat foo = round(foo, 0) to the end of your query, where 'foo' is the field displayed.
| fieldformat foo = round(foo, 0)
fieldformat not modify the number format precision;
integers with 0 are very ugly but its necessary in percentage
just go to edit mode