How to create comparsion charts for different timelines

[sureshkumar_kum]

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.

[ChadTurner · Accepted solution]

@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 :

[kunal_vaidya]

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

[Marcelo_santand]

@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")

regards!

[kunal_vaidya]

Thanks !! Will try it