topic Re: Classic dashboard not showing the format as data explorer shows in Dashboarding

Classic dashboard not showing the format as data explorer shows

Yosi_Neuman — Tue, 10 Sep 2024 06:45:17 GMT

Hi guys,

Customer asked to show metric that holds information in seconds in day:hours:minuts:secounds format

We used toUnit format and with in the data explorer its look grate 🤗

However when saving it to tile on dashboard its mess the format we waited for 🤔

This is a managed site running version 1.296.83

In SaaS (299.83) the same format is not working in data explorer 🙄

Can any one helps and explain if this is a bug in dashboard or data explorer or may be you have another why to show seconds in different format?

Thanks in advance for your inputs

Yos

Re: Classic dashboard not showing the format as data explorer shows

PedroSantos — Tue, 10 Sep 2024 14:54:19 GMT

Hey @Yosi_Neuman , I once again find myself trying to do something, finding the same difficulties and looking up answers on the community to find your post 😅

I was trying to do something similar with some query times, and the easiest way I've found to do this is just to duplicate the metric and use the "Unit" option to set it to what I needed. So in your case I think you'd remove the 'tounit' on the query itself and use the options on the right:

These options depend on the data type received. Mine was in seconds and these options were available. Maybe you'll have them too?

Mine looks like this:

And the query is just the same, duplicated for how many formats I want:

It ends up producing this in the data explorer (picture of partial table):

And then I just pinned it to the dashboard and it worked:

This is on a SaaS environment. See if it helps you?

Re: Classic dashboard not showing the format as data explorer shows

Yosi_Neuman — Wed, 11 Sep 2024 07:53:09 GMT

Hi @PedroSantos

Small community with good guys and information in it 🤗

First of all thanks for the detailed explanation.

In our case customer asks to see downtime from month begin till now.

We calculate a metric that hold a number which is the seconds of downtime from month begin.

We need to show this metric on dashboard in format of D:HH:MM:SS

IMO Because this is a calculate metric, its got no unit assign, hence we do need the toUnit in order to ask dynatrace to show the number in seconds for start.

With out toUnit

And the unit is not set

With toUnit

Now when getting to the unit we can see that dynatrace understand that we dealing with time metric

Each format we will pick will convert the number

And so on....

Actually now I understand that we are missing a format of DD HH:MM:SS .... maybe a product idea.

And as the old song says "we will meet again" 🤓

Thanks

Yos

Re: Classic dashboard not showing the format as data explorer shows

Yosi_Neuman — Tue, 24 Sep 2024 15:27:49 GMT

Hi again

Had some time to try and reproduce the issue and hope some one can help me here....

Don't ask how but I figure out that when I use: (1-(builtin:service.response.time)):splitby():setUnit(second) as metric expression the data explorer shows the the output as -8 d -11 h -42 min -40 s

And when I use ((builtin:service.response.time)-1):splitby():setUnit(second) the output is 7.4 d

First question is why when subtracting the format is dd:hh:mm:ss ?

Second question is why when saving the tile to dashboard the format is disappearing?

Any clue on what is going on here and why?

Yos

Re: Classic dashboard not showing the format as data explorer shows

zietho — Sat, 20 Dec 2025 07:22:40 GMT

Hey, maybe for others who run into this. This is a known limitation due to the fact that Dashboards classic and the Data explorer ran on different technologies and used different formatters..

I spare you the details but a thing where we rely on different formatters from the classic part and where we did not have much control over how the formatter reacts on both sides.. So yes indeed whenever you ran auto (did not decide on the way we show time, Data explorer does a better job but it can't/won't be used on the Dashboard.

And let me be transparent here. Given the internal dependency and the fact that the investment focus shifted there is no realistic chance we still gonna change that as of today.