cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to create comparsion charts for different timelines

sureshkumar_kum
Newcomer

I have a requirement to create comparison chart for a particular user action (Today vs Yesterday vs Last week). Has anyone done this before. I am running on the latest version of dynatrace.

Sample has been provided below.

3 REPLIES 3

ChadTurner
Leader

@Suresh K. Currently only certain graphs will allow the comparison. You can see this within any type of User Session SQL statements. Granted that is only for User session metrics. You can also compare over time with some single value dashboard tiles, as well as pure paths and so on by navigating to the transaction and services and selecting compare.

User Session SQL:

Transactions and Services :

-Chad

kunal_vaidya
Newcomer

Is there any new updates coming for comparisons ? Keen to check / comapre the units in some kind of stack graph. 

 

@kunal_vaidya  You could use something like this:

 

Select DISTINCT DATETIME(starttime, 'HH:mm', '30m'), COUNT(*) FROM usersession where useraction.application = "you app here" GROUP BY datetime(starttime,"HH:mm","30m")

 

Marcelo_santand_0-1623350269108.png

 

 

regards!