Productivity portlets has a pretty good display of the activity in terms of Applications and number of Query per Hour (QPH).
But ... i can't explain the QPH metrics: when requesting on QRYLOG table choosing an APPID and an hour in current day (StartTime) i expected to find the number of requests in accordance with the count(distinct QUERYID).
Instead, the figure displayed in Viewpoint is a about one thousands times the result of my request !
How to know the collected data on which this metric is based ?
Thanks for help,