We upgraded Pm to version 20.2.1.0. Since the upgrade I have a query that pulls data and is missing fields. When the query runs it pulls all the information for the first line. Then it summarizes the next columns that pertaining to that device. this repeats for every device in the query.
Example output of a query from the query builder
"DisplayName","device/Name","portmfs/Timestamp","portmfs/im_BitsPerSecondOut","portmfs/im_BitsPerSecondIn"
Gi1/1/2 - GigabitEthernet1/1/2,hostname,1600729200,2.27096396555556E7,1.72050958088889E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600732800,2.72405283555556E7,1.53491165377778E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600736400,2.212118588E7,1.44166839888889E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600740000,2.95509120755556E7,1.432290164E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600743600,2.15137247244444E7,1.679388552E7
Gi1/1/2 - GigabitEthernet1/1/2,,,1600747200,2.10736172844444E7,1.31675350755556E7
Query builder omitting fields in output
Release : 20.2
Component : IM Reporting / Admin / Configuration