topic Re: Create business journey dashboard by USQL in Dashboarding

Create business journey dashboard by USQL

AskMe-Solutions — Thu, 06 May 2021 12:00:24 GMT

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.

Re: Create business journey dashboard by USQL

ChadTurner — Tue, 17 Nov 2020 18:19:36 GMT

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.

Re: Create business journey dashboard by USQL

AskMe-Solutions — Wed, 18 Nov 2020 05:57:50 GMT

Hi chad,

Thanks for your response.