Hi
I have two trended parameters, let's say Input bitrate and Output bitrate and I want to visualize the calculation Input bitrate / Output bitrate on a trend graph. Note that this does not exist as a separate parameter on the connector.
How can I achieve this in the most convenient way? Is this possible without modifying the connector?
Kind regards,
Jonas
Hi Steve, thanks! Exactly what I needed. Would make sense to have this custom operator as an example on the catalog as well. The division is a use-case that might come back quite frequently
Hi Jonas, getting them added to the catalog is already in progress. Just having a proper developer take a look rather than using my code 😉
Hi Jonas,
As far as I know it is not possible to make operations on a trend graph (in Cube). As you suggested, this will imply a connector update. As Steve mentioned, you could use the GQI data source Get trend data to retrieve the data points of these KPIs (input/output rates) and use a custom operator (e.g SLC-GQIO-SumColumns) to perform operations.
To perform any operation between these two KPIs, it is required to have the corresponding data points in the same table. This can be achieved by using a join operator. However, keep an eye on the performance of the query. If you notice that your query is going into timeout, maybe it is worth to try the following ad-hoc data source SLC-GQIDS-TrendData.
Hope it helps.
Thanks for the adhoc data source code, will take this into account and use the adhoc if I would notice performance problems
Hi Jonas, does this have to be in the Trend graph? or can it be a Dashboard? You may be able to use a GQI to gettrenddata then a custom divide operator for your function and graph the results. There is a Dashboard example on Ziine named 'SPU-TrendCalculation'.