## Summary
- Replace duplicated ClickHouse queries in the users exceptions
dashboard with a shared hidden source panel.
- Optimize ClickHouse SQL with `GROUPING SETS`, `PREWHERE`,
`multiSearchAny`, and reduced repeated JSON parsing.
- Add category drilldown links from category panels and a visible reset
link.
## Performance
Local ClickHouse benchmark (3 cpu), same dashboard time (30 days) range
and `sources=All`:
- Before:
- duplicated main panel queries: ~70.9s total ClickHouse query time
- drilldown query: ~5.7s
- total: ~76.6s
- After:
- shared hidden source query for main panels: ~7.6-8.0s
- optimized drilldown query: ~5.2s
- total: ~12.8-13.2s
### Checklist
<!-- Go over all the following points, and put an `x` in all the boxes
that apply.
If an item isn't applicable for some reason, then ~~explicitly
strikethrough~~ the whole
line. If you don't do that, GitHub will show incorrect progress for the
pull request.
If you're unsure about any of these, don't hesitate to ask. We're here
to help! -->
- [x] I submit my changes into the `develop` branch
- [ ] I have created a changelog fragment <!-- see top comment in
CHANGELOG.md -->
- [ ] I have updated the documentation accordingly
- [ ] I have added tests to cover my changes
- [ ] I have linked related issues (see [GitHub docs](
https://help.github.com/en/github/managing-your-work-on-github/linking-a-pull-request-to-an-issue#linking-a-pull-request-to-an-issue-using-a-keyword))
### License
- [x] I submit _my code changes_ under the same [MIT License](
https://github.com/cvat-ai/cvat/blob/develop/LICENSE) that covers the
project.
Feel free to contact the maintainers if that's a concern.
---------
Co-authored-by: Peter Iosipov <61969939+yaizkazani@users.noreply.github.com>
Andrey Zhavoronkov
02e1144837