There are numerous instances where I am trying to display data using the Custom Chart resource but the unit type will display incorrectly and a I will need to write a SWQL query to fix this. I have a few examples of this:
For 'Target - Total Server Memory' the data will display as KB using the 'Bytes' unit type:
But in AppInsight the same data will be correctly displayed as MB:
This occurs again with Page Life Expectancy:
Here, I am using the custom unit 'Sec' because the data is being displayed as '467,088.00' which is obviously seconds. Using the unit type of milliseconds doesn't work at all as it does not convert to seconds, minutes, hours, days, etc.
In AppInsight, again you can see that the conversion has taken place and it is showing in hours.
I think it would be great if a 'Transform' option could be implemented into custom charts. For instance, you could choose the 'Bytes' unit type and format it like Bytes * 1024
This would work with milliseconds too, something like milliseconds * 1000 * 60 (for ms into sec and sec into min)
What do you think?
