i want to write this User Session Query:
SELECT useraction.name, COUNT(errorCount) from useraction WHERE name="name-of-useraction" GROUP BY useraction.name. It's work, but i must change the useraction's name (only in this query, i can't change the real name). I tried some like this query, withuot success:
SELECT useraction.name, COUNT(errorCount) from useraction WHERE name="name-of-useraction" AS "name-changed" GROUP BY useraction.name
The AS command doesn't work in this case, so how can i change my useraction's name in this query?
Solved! Go to Solution.
Oh I see the misunderstanding, you're not changing the name itself by doing an alias. You're changing the column name (i.e. what shows up in the column header in a table). I don't believe you can just rename the action like that outside of the funnel function.
Depending on what you're trying to do I'd just leave off the action name and use either an alias on the error count field or just the usql query name to specify what you'd like to refer to the action as: