Hi
I’m using the first() function in the select statement and want the y axis to be sorted based on when the first time the user logs on, therefore giving a stepped output rather than the output as can be seen in the attached pic.
Does that make sense?
SELECT first("value") AS "first_value" FROM "login"."autogen"."realtime_login" WHERE time > :dashboardTime: AND "environment"='Prod' GROUP BY time(:interval:), "user" FILL(previous)
