Hi Dojo team,
I have two questions on Dashboards:
- Is it possible to rename or duplicate a numerical column and keep it as numerical?
- 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
Hi Yahya,
- 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.
- 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
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.
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.