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
Expanding on the answer above, our user needed to use an elements parameter lookup and a custom property value for the calculation. We put together the attached automation script ‘CustomProperty-DivideColumns.xml’ which creates a Custom Operator called ‘CustomProperty-DivideColumns’. This then prompts the user for the Dividend Column / Divisor Column = New Column Name (Quotient).
CustomProperty-DivideColumns.xml
Results table:
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