Hello DOJO
In a dashboard, I am trying to count and graph the number of values for a field in table
- less than 12db
- between 12 and 18
- greater than 18
So, at the end, I am expecting 3 lines, to count the number of "terminal name" whom the value is in the scale above
Its OK if I do this request on a string value (one line for each possible state)
it's also OK by using one condition like : greater than or equals 12
but it give just one line as expected
How is it possible to do the same on one field but by counting the number of values related to the thresholds ?
example:
Hi Joel,
For a use case like this we need to refer to a feature which is still behind the 'GenericInterface' soft launch flag, called 'Custom operators'.
A custom operator let's you implement a certain C# interface to, as the name suggests, let's you define the behavior of an operator.
In your case, the custom operator could take the values of the 'Db' column and transform that to another value in a new column (e.g., Low-Medium-High). You can then use these new values for aggregating.
Feel free to let me know if you want to try this on a staging environment, then we can already forward you the necessary information.
Hi Joel, I’ve sent you some additional information. Please let us know if you have any feedback or problems while using the user definable operator. As this feature is still in soft launch, it should not be used in production.
Note that you can now also find more information about the custom operator in the documentation: https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/GQI_Custom_Operator.html
Thanks Sebastiaan
yes indeed We are interested to be able to test this feature
If it succeeds, could we put it in a production environment ?