calculate average of two columns in custom report

Hi menekse ,

This could either be a rounding issue or a difference in the selected time range between both reports.

Could you give us more information on the formula you selected and the report setup.

regards,

Isaka

Hi Isaka,

i chose Default Duration time last 15 min in two of report configuration (main and child report) and i used formula that "math.spatial.Average" and filtered name=='Availability' in child report(screenshot 3), value of Report Details:Table as a Selected value :Average (screenshot 2). i added screenshot. i hope i can explain. Thank you.

Hi menekse ,

This looks like it should work, i will setup a similar report in the lab to troubleshoot this further and let you know my findings.

regards,

Isaka

Hi menekse ,

I have been able to replicate the issue in the lab...however the Summary Settings of the column does return the correct value.

I will dig into it a bit more.

regards,

Isaka

i changed it but solution not correct again. I got results of 97.53

Have you tried modifying the time management settings on the availability column of the table?

Hi menekse ,

From my testing the discrepancy appears to happen when a table row selects multiple metrics, when i modified my filter and expansion to have a single metric per row.

You should be able to confirm this by clicking on the Availability % value for the devices and you will notice that there are multiple lines...one for each metric, like shown below.

Regards,

Isaka

Hi Isaka,

Yes i can see with chart but It is not professional to show such a result. I think EMC should fix this.

Thank you.