But now I want to get the Returning users count, so I want to know how many of the unique users are returning users. How do I query that?
I have been looking through the azure application insights blades and metrics to get that, the only place I could find it was under Usage => More => New, Returning and Churrned Users. It seems to be querying what I want:
So I want to get this query for myself so I can get the Returning users count on a daily bases, via the api.
When clicking on Edit at the top of the page, I can edit each individual item on the page, so I can now also edit the graph. When I do that, I can see the query, which is as follows:
Awesome, I thought, but unfortunately it does not work correctly, there is even a button to open the query in the Query Logs View.
But I don't really get how the query is build to get Returning Users. According to the query this should be defiend by "s1" which I cannot see to be defined anywhere. Also, I am a noob to this query language, so I would highly appreciate if someone could tell me how to adjust this query so that it only provides the Returning users count using a start and end date.