Create business journey dashboard by USQL

[AskMe-Solutions]

Hi All,

How try create journey dashboard for this picture?

How can write usql ?

descriptions

-Bar chart is average of all usersession

-LB is average of userId by tag

-Av Case/LB is LB divide Bar chart

Thank you.

[ChadTurner · Accepted 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.

[AskMe-Solutions]

Hi chad,

Thanks for your response.