更なるアドバイスありがとうございます。 「eval pTime=tostring(pTime, "duration")」を加えますと 統計情報のタブでは"HH:MM:SS"形式で出力されます。 しかし、視覚エフェクト（Line ChartやColumn Chart）では Y軸は"HH:MM:SS"形式で出力されないです。 -------------------------------------------------- [English translation by Google translation] Thanks for any further advice. If you add "eval pTime=tostring(pTime, "duration")" In the statistics tab, it is output in "HH:MM:SS" format. But in visualizations (Line Chart and Column Chart) The Y-axis is not output in "HH:MM:SS" format... -------------------------------------------------- ... View more

アドバイスありがとうございます。 >There is a way to do this. the first question is: in your data, is the _time field of the event equal to the processing time (処理時間)? いいえ、異なります。 データの例としては | makeresults | eval _raw="baseDate,start,end,procTime 2023/05/01,2023/05/01 09:00:14,2023/05/01 09:03:17,183 2023/05/01,2023/05/01 09:03:17,2023/05/01 09:04:57,100 2023/05/01,2023/05/01 09:04:57,2023/05/01 09:08:48,231 2023/05/02,2023/05/02 09:00:11,2023/05/02 09:03:18,187 2023/05/02,2023/05/02 09:03:18,2023/05/02 09:05:31,133 2023/05/02,2023/05/02 09:05:31,2023/05/02 09:09:14,223 " | multikv forceheader=1 | chart sum(procTiem) as pTime by baseDate というデータに対して、Y軸となる pTime を "HH:MM:SS"形式にしたいです。 -------------------- [English translation by Google translation] Thank you for your advice. >There is a way to do this. the first question is: in your data, is the _time field of the event equal to the processing time? No, it's different. An example of data is | makeresults | eval _raw="baseDate,start,end,procTime 2023/05/01,2023/05/01 09:00:14,2023/05/01 09:03:17,183 2023/05/01,2023/05/01 09:03:17,2023/05/01 09:04:57,100 2023/05/01,2023/05/01 09:04:57,2023/05/01 09:08:48,231 2023/05/02,2023/05/02 09:00:11,2023/05/02 09:03:18,187 2023/05/02,2023/05/02 09:03:18,2023/05/02 09:05:31,133 2023/05/02,2023/05/02 09:05:31,2023/05/02 09:09:14,223 " | multikv forceheader=1 | chart sum(procTiem) as pTime by baseDate For the data, I want to format pTime, which is the Y axis, in "HH:MM:SS" format. ... View more