{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Adapter for Envoy
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • 日本語コミュニティ
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • Analytics /
avatar image
1
Question by Kim Vandendijk · Mar 18, 2019 at 11:55 AM · 103 Views analytics

Drilldown custom report

I want to create a report that defines response time and errors of request uri's. When I click on one of the request uri's, I want to see the devision between the 4xx errors and 5xx errors for that specific uri. However, when I click on a uri, I get the devision between the errors of all uri's, i.e. the sum of errors by error devision is equal to the sum of errors by uri division. Currently I have my report set up as follows:

In my custom report I define 4 metrics:

1. Total Response Time

2. Target Response Time

3. Proxy Errors

4. Target Errors

I have 2 dimensions:

1. Response Status Code

2. Request URI

And the following filter:

(response_status_code ge 400) and (response_status_code le 499) and (apiproxy eq '<apiproxy>') or (response_status_code ge 500) and (response_status_code le 599) and (apiproxy eq '<apiproxy>')

If I just use the filter (apiproxy eq '<apiproxy>'), the drilldown somehow works correctly. However I only want to see the fault errors. Any ideas on how to proceed?

Comment
Add comment Show 1
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Dino-at-Google ♦♦   · Mar 19, 2019 at 03:39 PM 0
Link

What happens if you just filter on response_status_code, and not on apiproxy?

What happens if you eliminate the parentheses?

Close

1 Answer

  • Sort: 
avatar image
1

Answer by Kim Vandendijk · Mar 19, 2019 at 05:05 PM

After some trial and error I found the issue was in the definition of the filter. When I use the filter ((response_status_code ge 400) and (response_status_code le 599)) and (apiproxy eq '<apiproxy>'), the drilldown works as expected. So this would be equal to adding brackets around the 2 different 'or' parts in the filter of my initial post.

However, this filter got set by the automated report generation in the alert setup and now each time when I change an alert it resets the filter back to the incorrect one in my initial post. For now, I will disconnect the reporting from the alerts, but for my use case I would really like to see this issue fixed. We are trying to enable our support team to quickly respond to alerts based on apigee analytics and linking the alert and the report would help.

Comment
Add comment Show 1 · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Dino-at-Google ♦♦   · Mar 20, 2019 at 03:12 PM 0
Link

Thanks for the update Kim.

I understand the problem and you have a good point.

I've raised b/128980639 on your behalf. We'll try to get it fixed quickly. If you want to track the status of that bug formally, you can contact Apigee Support and ask them to open a ticket for that purpose.

Follow this Question

Answers Answers and Comments

47 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

analytics filter - invalid API call 4 Answers

Missing analytic data 1 Answer

How to use "Resource Flow" Dimension in Analytics 4 Answers

What is the best way to distinguish between EMG API analytics and SaaS API analytics 2 Answers

Analytics report with custom attributes 1 Answer

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2021 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Adapter for Envoy
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • 日本語コミュニティ
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Badges