-
Top clients requesting devices
Good day, I want to create a beast mode statement that gives me a list of all the clients who have requested more than two devices each month. The final outcome would look like this: Request Date Individual_ID # of Requests 2024-Jan 12345 2 56789 3 11234 4 56789 2 2024-Feb 12345 5 56789 4 11234 5 56789 2 So far this is…
-
Grouping 'Last Connection Time' by month
Looking to create a Beast mode that will break MAX(`Verizon_Last_Connection_Date`) into chunks by quarter. Example below. I am able to validate the calculation, however it does not seem to work when I add this formula to the series. It just displays '1 month' and 'over year'. CASE WHEN DATEDIFF(CURRENT_DATE(),…
-
Application upgrade tracking
I am tracking an application update on devices. I have a dataset that looks something like this. I would like to: 1. Count # of devices that upgraded to the latest app (Column App1). Ex. is 1002 and 1004 that has 2 versions, I only need the latest which is in column App1. 2. Count # of devices with app1 and app2 3. Count…
