Help with CPU and memory charts in custom dashboard

[NicoleMT]

Hi everyone,

I’m having an issue with the charts shown under "Infrastructure & Operations" in the Hosts section. There, I can see the CPU and memory metrics that I’m interested in.

I tried sending those charts to the Dashboard App to build a custom dashboard, but the chart looks different from the original one. I tried adjusting it manually, but I can't get it to display the same information or look the same.

Dql memory:

timeseries avg(dt.host.memory.used), by:{dt.entity.host}, filter:dt.entity.host=="HOST-8716BCAE1947C94C" | fieldsAdd metricName = "Memory used"
| append[timeseries avg(dt.host.memory.recl), by:{dt.entity.host}, filter:dt.entity.host=="HOST-8716BCAE1947C94C" | fieldsAdd metricName = "Memory reclaimable"]
| append[//queryId=HostMemoryKernel
timeseries m1=avg(dt.host.memory.kernel),by:{dt.entity.host}, filter:dt.entity.host=="HOST-8716BCAE1947C94C"]
| append[//queryId=HostMemoryTotal
timeseries {
available = avg(dt.host.memory.avail.bytes),
used = avg(dt.host.memory.used)
}, by:{dt.entity.host}, filter:dt.entity.host=="HOST-8716BCAE1947C94C"
| fields `Capacity` = used[] + available[], interval, timeframe | fieldsAdd metricName = "Memory available"]

Could someone please help me replicate those charts properly in my own dashboard?

Thanks in advance!

[Akhil-Jayendran]

Hi @NicoleMT ,

From "Infrastructure & Operations"  app, you have option to pin those chart into your dashboard. have you tried that ?

While adding to that dashboard, by default it will select for line chart but you can edit it and visualize to area chart if you want to.

You will get exactly same date there.

BR,

Akhil

[NicoleMT · Accepted solution]

Hi....

Hi, yes I did that, but as you can see, the chart is incorrect. The used memory exceeds the capacity, and the Y axes (left and right) are showing different units: GB and G.

How can I make it display correctly, like it does in the Hosts view?

[Akhil-Jayendran · Accepted solution]

Hi @NicoleMT , 

I think I understand your issue now. When plotting the graph in the dashboard, it uses DQL behind the scenes.

It primarily uses three metrics: Memory Used, Memory Reclaimable, and Memory Available (Capacity). To calculate Memory Available, DQL performs some arithmetic operations, which may result in a unit conversion.

You could try using the notebook feature, where there’s an option to override unit settings — for example, converting from Bytes to GB.”

I have tested and it worked for me. I think it worth to test it 



Note: My system behaved abnormally and accidentally selected ‘Accept Solution’. Unfortunately, I don’t have an option to revert it. 😞 

[Nicky]

Hi team, 

Hi, I’m also experiencing the same issue with the charts in the new dashboard, especially with the disk usage metric. I’m not sure how to fix this. Could you please guide us?

Best regards,