Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

Please make sure you have read through the Prerequisites / Basic Set-up.

You will need to fit the name of the datasource and of the table to your own Confluence installation.

See your top 10 queries ordered by amount of all time views.

Query

Query
SELECT QUERY_NAME,
       COUNT(ID) AS VIEWS
FROM AO_AD3311_MACRO_USAGE 
GROUP BY QUERY_NAME
ORDER BY VIEWS desc
LIMIT 10;

TIP: Add a WHERE clause to see the top 10 queries of the month, or week. For MySQL you could use this:

WHERE DATE >= DATE_ADD(CURDATE(), INTERVAL -7 DAY)


Template

Template
<script>
PocketQuery.chart('ColumnChart', {
  legend: {position:'none'}
});
</script>
Download this example!


PQMU-top-queries.xml


Download the export file with the entities on the left and import it in your PocketQuery administration.

  • No labels