Hello - I am still finding my feet with NRQL and understanding which dashboard technology I am supposed to use in NewRelic (I still find it very confusing, what is old, what is new?)
So I think NewRelicOne is what I’m supposed to use these days right?
So I have taken a query suggested to me in the browser section, to give me a quick idea on the number of users hitting our site (we haven’t got Google Analytics embedded in our app, and I am hoping NewRelic can get me most of the info I need - its supposed to do this right?)
So I thought that the following would do this:
SELECT uniqueCount(session) FROM PageView SINCE TODAY
And variants of it would show me yesterday, this week, this month? e.g.
SELECT uniqueCount(session) FROM PageView SINCE YESTERDAY
SELECT uniqueCount(session) FROM PageView SINCE THIS WEEK
SELECT uniqueCount(session) FROM PageView SINCE MONTH
I get numbers for the above that are similar to this: 605, 850, 660, 660 ?
So I don’t understand this - yesterday was busier (but today isn’t quite complete), but why would this week only be marginally bigger than today (and less than yesterday?), and why would this month be the same as this week? This makes no sense to me?
Am I misunderstanding what these kinds of queries should do? Or have I got some data setting wrong?
I’m getting more and more confused trying to understand the data the NR is supposed to get to me.
Thanks for the help,