We have the need to perform some calculations on a table to generate a result.
CellA * Cell B = NewValue to display
CellA / Cell B = New Value to display
Is there a way to perform this in a dashboard using GQI or other method?
The other requirement is that the result is part of the export to csv when selected or scheduled.
Hi Steve,
As far as I know you will need a GQI operator. Checking the repository, there are a couple of GQI operators that can be used as reference to create a new one that performs multiplication/division:
Hope it helps.
Hi Randy, that’s in the Automation interface in Cube (although it’s not a real automation script), more info about customer operators in our docs: https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/GQI_Custom_Operator.html
Where is the code for the Custom GQI Operator placed. Is it in the automated scripts or is it in a directory under Skyline Dataminer