Query Tips and Tricks

More ways to modify your Query Charts

Hide "Others" on a Stacked Chart

Sometimes you will do a Breakdown by a high-cardinality Field in your Query. In this case you will get a group called Others on Stacked charts and it may be a substantial percentage of the overall results. But what if you wanted to see the percentages on your Stacked chart calculated based on what's shown on the chart? Then you should click the Hide Othersbutton:

Zoom-in and Out

When you're looking at a Chart with multiple Breakdown Groups you can zoom-in on a particular Day/Week/Month/etc (depending on the Date Range and Time Unit of the Report) to see the distribution during that time by left-clicking on a data point and then Zoom-in. To go back to bird's-eye view click the x in the top right corner.