topic Re: How to create comparsion charts for different timelines in Dashboarding

How to create comparsion charts for different timelines

sureshkumar_kum — Wed, 31 Aug 2022 09:54:13 GMT

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.

Re: How to create comparsion charts for different timelines

ChadTurner — Tue, 17 Mar 2020 12:45:13 GMT

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

Re: How to create comparsion charts for different timelines

kunal_vaidya — Thu, 10 Jun 2021 03:26:59 GMT

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

Re: How to create comparsion charts for different timelines

Marcelo_santand — Thu, 10 Jun 2021 18:39:49 GMT

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

Re: How to create comparsion charts for different timelines

kunal_vaidya — Thu, 24 Jun 2021 05:29:36 GMT

Thanks !! Will try it