The unfortunate reality is that the new Lite version (since about a year ago) is pretty limited - requires a fairly expensive paid plan to get the needed long-term data.
The most beneficial way to use the Lite version - and which should give you the general info you’re looking for - is to go into your Account Settings and under User Preferences, click to be sent the weekly summary report in email. That report will show daily CPU and RAM usage for each app on your account. (see screenshot)
Note! - to make life easier, go to the Setting section of New Relic dashboard for each APP and assign real website names to the cryptic Cloudways App names. Much easier for monitoring if you have a number of websites on a server.
For more immediate checks of individual websites, you can go to the APM dashboard and click on one of your Apps. Then select a time frame of “last 24 hours” in the time picker on the top menu bar.
Now, look at the bottom data block where it will list things like response time, CPU usage and memory. This info is more or less a per-app version of the server-wide monitoring that CW gives you in their dashboard. To make it more useful, click the little graph icon beside the list icon in the upper right corner of that specific data area - you’ll now get a timeline of CPU and RAM usage over that 24 hour period.
Unfortunately, you’ll need to come back to this report repeatedly to monitor usage patterns over longer periods of time, as the report is limited to max 24 hrs. That’s where the weekly report I mentioned at the beginning becomes more useful. This specific report can be used for troubleshooting when you’re in the middle of an issue though, instead of having to wait a week for the email report.
Hope that helps you get what you’re looking for?