https://community.dynatrace.com/t5/Dashboarding/Single-value-tile-with-sparkline-and-trend-as-in-classic-metric/m-p/231250#M3481 <P>I have tried simple single value via timeseries cpu=avg(dt.host.cpu.usage) data.</P> <P>I had learned that output of timeseries is array, so single value is not possible (blank widget without any info, but it shows trend at least, when i select timeframe/interval as input data).</P> <P>Another try was timeseries cpu=avg(dt.host.cpu.usage)|fields cpuavg=arrayAvg(cpu).</P> <P>This produces nice single value but doesn't allow to visualize sparkline, nor trends (as it's only single number obviously).</P> <P>I had tried to push array as well via timeseries cpu=avg(dt.host.cpu.usage)|fields cpu,cpuavg=arrayAvg(cpu), but sparkline does not allow to use cpu array as data source (shows None as record field only option).</P> <P>I know it's only early access, but any hints how to achieve such a simple task ? (single value with sparkline and trend as in classic metric explorer)</P> Mon, 05 Aug 2024 09:07:34 GMT rastislav_danis 2024-08-05T09:07:34Z https://community.dynatrace.com/t5/Dashboarding/Single-value-tile-with-sparkline-and-trend-as-in-classic-metric/m-p/231250#M3481 <P>I have tried simple single value via timeseries cpu=avg(dt.host.cpu.usage) data.</P> <P>I had learned that output of timeseries is array, so single value is not possible (blank widget without any info, but it shows trend at least, when i select timeframe/interval as input data).</P> <P>Another try was timeseries cpu=avg(dt.host.cpu.usage)|fields cpuavg=arrayAvg(cpu).</P> <P>This produces nice single value but doesn't allow to visualize sparkline, nor trends (as it's only single number obviously).</P> <P>I had tried to push array as well via timeseries cpu=avg(dt.host.cpu.usage)|fields cpu,cpuavg=arrayAvg(cpu), but sparkline does not allow to use cpu array as data source (shows None as record field only option).</P> <P>I know it's only early access, but any hints how to achieve such a simple task ? (single value with sparkline and trend as in classic metric explorer)</P> Mon, 05 Aug 2024 09:07:34 GMT https://community.dynatrace.com/t5/Dashboarding/Single-value-tile-with-sparkline-and-trend-as-in-classic-metric/m-p/231250#M3481 rastislav_danis 2024-08-05T09:07:34Z https://community.dynatrace.com/t5/Dashboarding/Single-value-tile-with-sparkline-and-trend-as-in-classic-metric/m-p/252902#M4151 <P>I think your approach is almost perfect but, when you use&nbsp;<EM>fields</EM> you limit the amount of fields returned in the query. You can directly add the extra calculation with <EM>fieldsAdd</EM>.</P><P>I believe the following query should fit your needs and let you visualize everything in a single value tile:<BR /><BR />timeseries cpu=avg(dt.host.cpu.usage)<BR />| fieldsAdd cpuAvg=arrayAvg(cpu)</P> Thu, 08 Aug 2024 10:30:46 GMT https://community.dynatrace.com/t5/Dashboarding/Single-value-tile-with-sparkline-and-trend-as-in-classic-metric/m-p/252902#M4151 Alejandro 2024-08-08T10:30:46Z