16 Nov 2020 11:54 PM - last edited on 06 May 2021 05:00 AM by MaciejNeumann
How try create journey dashboard for this picture?
How can write usql ?
-Bar chart is average of all usersession
-LB is average of userId by tag
-Av Case/LB is LB divide Bar chart
Solved! Go to Solution.
I'm not 100% sure we can include the division and the weekly dates in a chart. The basic chart I was able to create was the following:
SELECT COUNT(userId) FROM usersession WHERE useraction.application="**APPNAME**"
You can expand on this but I'm not sure if you can get the math in place or the dates as the time goes by the Time Frame Selector on the top of the screen.
Thanks for your response.