I have been looking for a way to group information by name and date.
We have a setup with thousands of tests running on different products, what I want to do is fetch all failing test cases but only count them once per date. So if a test has failed on 5 different products it should only be registered as one fail that specific day.
I guess this would be the corresponding sql queery if it was a mysql database:
SELECT test_name, count(DISTINCT DATE(timestamp)) FROM mysql_test GROUP by test_name;
Thanks and all the best