Modification

[ramprakash]

Please advise.

[to4kawa · Accepted solution]

index =* source=*MIG* a_agent=* | bin spans=1d _time | stats count by _time a_agent | eval time=strftime(relative_time(now(),"@h"), "%F %T") | eval report="SBB0;INtegrationPLatform;".a_agent.";".count.";".time| fields - _* |table report

[ITWhisperer]

Have you tried transpose?