Missing Average TPS in Custom Report jobs

[chungss1]

I have setup a Custom Report that will return the metric:

• Traffic Sum
• Average TPS

When viewing the report normally (less than 14 days), the report will show the Avg TPS as expected.

However, when submitting a Report Job (more than 14 days), the report will not show the Avg TPS.

Is this a bug? I am on Public Cloud.

[dknezic]

The tps metric doesn't support aggregate functions

https://cloud.google.com/apigee/docs/api-platform/analytics/analytics-reference#metrics

Some other options

- You have a traffic sum, you could try to infer TPS by processing the result of your async report outside of apigee

- There's a tpm metric available as well. (You could try tph too)

https://docs.apigee.com/api-platform/analytics/asynch-reports-api#example3

[chungss1]

I would prefer if I can extract the report via the UI, after all the feature is there to be used.

Just felt it weird that for synchronous report (less than 14 days), the Avg TPS is showing as expected.

But when running as a job (asynchronous, more than 14 days), the Avg TPS is missing.