How to show all 1 month old data

I would like to see 1 month old data on dashboard and when I select that in query as like below , it just shows first few rows but not all rows which falls under 1 month criteria. Any one knows how to ?

SELECT * FROM Transaction WHERE appName = ‘<>’ and XYZ is NOT NULL since 1 month ago

Try adding LIMIT MAX to your query:

SELECT * FROM Transaction WHERE appName = 'Your Application' AND XYZ IS NOT NULL SINCE 1 month ago LIMIT MAX

That will show all available data, up to the maximum number of rows allowed per query. Note that your account may not retain 30 days of event data.

3 Likes

Thank you. It worked.