[| makeresults | addinfo | eval earliest=relative_time(info_min_time,"@d+7h") | eval latest=relative_time(info_min_time,"@d+31h") | fields earliest latest]| fields file_name batch_count entry_addenda_count total_debit_amount total_credit_amount |dedup file_name | eval total_debit_amount=total_debit_amount/100, total_credit_amount=total_credit_amount/100 | table _time file_name batch_count entry_addenda_count total_debit_amount total_credit_amount
I am using above query But want to show 2 different time zone PST and UTC in the table. Right now the time shown is in UTC
... View more