{ 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
0
Question by Ramya S M · Jun 17, 2016 at 08:53 AM · 274 Views analyticsfiltering

issues with analytics filters

Hi ,

we tried to use filter condition as filter=(message_count eq 30) and with select=sum(message_count), but we are getting null data .

API call thats made by the edge UI are ,

1) Without filter condition , select condition as sum(message_count)

/stats/apiproxy?_optimized=js∾curacy=100&limit=14400&select=sum(message_count)&sort=DESC&sortby=sum(message_count)&timeRange=06%2F14%2F2016+00:00:00~06%2F21%2F2016+00:00:00&timeUnit=hour&tsAscending=true&tzo=330

the graph shows that for a particular proxy sum of traffic is 30.

2) With filter condition as (message_count eq 30) and select as sum(message_count)

/stats/apiproxy?_optimized=js∾curacy=100&filter=(message_count+eq+30)&limit=14400ℜtime=true&select=sum(message_count)&sort=DESC&sortby=sum(message_count)&timeRange=06%2F17%2F2016+13:23:00~06%2F17%2F2016+13:33:00&timeUnit=minute&tsAscending=true&tzo=330

this shows the null data in graph.

Can u please explain why the filter condition is not working?

Whats exactly the difference between sum(message_count) and message_count ?

Thanks,

Ramya

Comment
Add comment
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

Close

1 Answer

  • Sort: 
avatar image
0

Answer by Sukhesh Gopala · Jun 21, 2016 at 08:10 AM

Filters are applied on individual records. Your first query returns 30 as the sum over number of records over a time period. Your second query tries to apply the filter "(message_count+eq+30)" to individual records which doesn't hold good on any record.

Comment
Add comment Show 2 · 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 gbhandari   · Jun 21, 2016 at 11:07 AM 0
Link

@Ramya S M

Sukhesh has correctly pointed out the reason behind the different output.

Also, the time mention in the Management API call is in UTC where as that in the Management UI is depends on the time running on the server.

avatar image Ramya S M · Jun 23, 2016 at 08:17 AM 0
Link

Thanks @Sukhesh Gopala , @gbhandari ,

Can u please suggest what should be the correct query if i want to check the traffic of apiproxy which is greater than 30?

and also We tried creating a new custom report to plot graph for traffic and api proxies , with metric as Traffic , aggregate function 'sum'. we could get data for this , with one proxy having sum of traffic 30. when we applied filter as traffic = 30 then the there was no data found.

Follow this Question

Answers Answers and Comments

24 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

Related Questions

Is there a way to get the custom report for a specific user? 1 Answer

Compound Filters with Analytics API 1 Answer

analytics filter - invalid API call 4 Answers

Missing analytic data 1 Answer

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

  • 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