topic Re: Change column name and value for money in DQL

Change column name and value for money

WellPP — Wed, 11 Oct 2023 16:33:49 GMT

1. Is it possible to change the column name? Maybe it's possible to add a title to the table?

2. Is it possible to change the display to total in dollars?

Re: Change column name and value for money

natanael_mendes — Wed, 11 Oct 2023 20:32:35 GMT

you can use alias like this

fetch logs
| fieldsRename severity=loglevel, source=log.source, logmessage = content

Here the documentation page

https://www.dynatrace.com/support/help/shortlink/dql-commands#fieldsRename

feel free to ask if you have any doubts

Re: Change column name and value for money

WellPP — Wed, 11 Oct 2023 20:46:25 GMT

It worked out! Thank you very much!

Do you know anything about inserting a title for the table to be displayed on the dashboard? I'm still unsure about how to convert the amout value to money

Re: Change column name and value for money

natanael_mendes — Wed, 11 Oct 2023 23:48:07 GMT

welcome buddy, if you can mark the answer as a solution would be great

Re: Change column name and value for money

Eduard — Tue, 26 Mar 2024 07:45:17 GMT

HI, is there a way to rename the column names when representing 2 metrics on a table such as:

The idea is to assign a column name to metric A and another to B.

Thanks!

Re: Change column name and value for money

michiel_otten — Tue, 26 Mar 2024 07:48:13 GMT

Hi Eduard,

Within the data explorer you can rename columns of a table by using the settings menu on the right:

Is this what you are trying to achieve?

Re: Change column name and value for money

Eduard — Tue, 26 Mar 2024 08:08:02 GMT

Yes! It was so in front of my face that I didn't see it!

Thank you!