Dashboards: renaming numerical column and fixing the number for the Top X

Solved258 viewsDashboard and Query
0
0 Comments

Hi Dojo team,

I have two questions on Dashboards:

  1. Is it possible to rename or duplicate a numerical column and keep it as numerical?
  2. Is there a way to define the exact number for the Top X outside of the query, such as in a dropdown component?

Thank you!

Yahya Mesmoudi [DevOps Advocate] Selected answer as best 26th June 2024

1 Answer

3
5.08K 2 Comments

Hi Yahya,

  1. There is a 'Rename column' custom operator available on the catalog that can be used for this. An other option would be to rename the column using a 'concatenate' column manipulation with only that column. Afterwards you would have to use the 'Parse number' operator to parse it back to a number.
  2. No, there is currently no way to feed a value to to the 'X' of the Top X operator. I have created a task for us to implement this.
Yahya Mesmoudi [DevOps Advocate] Selected answer as best 26th June 2024
Yahya Mesmoudi [DevOps Advocate] commented

Thank you, Wout, for the answer elements.

In my particular case, I am unable to proceed because the DMA I am using is not on the Skyline Cloud, which prevents me from deploying anything from the catalog.
Wout Mahieu [SLC] [DevOps Catalyst] commented

That is no problem, the source code for both operators is also available on our github (https://github.com/SkylineCommunications/SLC-GQIO-RenameColumn & https://github.com/SkylineCommunications/SLC-GQIO-ParseNumber). You can add these script manually to your DMS.