Hello to everyone, I have a few questions about the statistics query. I have a very simple query like in the picture, I want to see the unique fromid value in long date ranges. The value here is 10s. I have two questions.
First of all, as the time interval increases, for example, within a period of 1 year, the query result does not come at all. The screen remains white. We are talking about a data of about 12m. Also, the distinctValues value is too long in queries as months. I don't want to deal with this field. The countDistinct value that matters to me My second question is, is there a different, faster method for fromid? image : https://ibb.co/TgjmvDC
