Hi Dojo,
Currently I am using DataMiner Version 10.3.7.
I have activated soft-launch option and enabled GenericInterface.
What are the next steps to get multiple methods in Aggregate Operator?
Hi Nehal,
Could you provide me with some more info about what exactly you are trying to achieve?
GQI is a perfect fit if you want to generate meaningfull metrics and insights in your data.
Out of the box, we provide some data sources and operators:
- Data sources: https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Query_data_sources.html
- Operators: https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Query_operators.html
If you want to do some custom calculations, you can write your own operator, more info (+examples) about that can be found here: https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/GQI_Custom_Operator.html
Also, we recently published a Kata session, an interactive learning session, about this topic: https://community.dataminer.services/courses/kata-5/
Best regards, Ward
Users, SessionId, Page, Time Spent
abc, bd1107a8-9974-4cd8, Home, 0:01:30
abc, bd1107a8-9974-4cd8, playback, 0:00:16
abc, bd1107a8-9974-4cd8, Home, 0:00:14
abc, bd1107a8-9974-4cd8, event, 0:00:24
abc, bd3f5a12-1478-2719, Home, 0:01:20
abc, bd3f5a12-1478-2719, event, 0:00:15
pqr, 1e22faa7-9ea3-4498, Home, 0:01:30
pqr, 1e22faa7-9ea3-4498, event, 0:01:30
xyz, 03279dcb-21e5-4c24, Home, 0:00:33
xyz, 03279dcb-21e5-4c24, event, 0:00:12
xyz, 03279dcb-21e5-4c24, playback, 0:00:15
xyz, 82908fd8-8f28-4d78, Home, 0:01:30
xyz, 82908fd8-8f28-4d78, playback, 0:00:21
xyz, 82908fd8-8f28-4d78, event, 0:00:02
xyz, 82908fd8-8f28-4d78, playback, 0:00:20
I have users with different session Id’s who are visiting different pages of a website. I can group it by users, session id and page as per requirement using “Group by” function in Query.
I wanted sum of time spent by users on particular page but getting only “Count” & “Distinct Count” aggregation method.
How can I get “Sum” as aggregation method?
I have activated soft-launch option and enabled GenericInterface.
Hi Nehal, sorry for the late reply!
That ‘Time Spent’ column is probably of type TimeSpan?
It is indeed not yet possible to take the sum of a TimeSpan column. A new software feature would be needed to add that functionality to GQI. I created a task for our team to further follow-up on this.
For now, the sum can be calculated only on numeric columns.
Best regards, Ward
Indeed! Also please be aware that all custom operators can be found after selecting the ‘Apply custom operator’ item. Currently, there is no method to extend the potential aggregations offered when selecting the ‘Aggregate’ operator. Furthermore, we are actively developing a new feature that will inform a custom operator when all rows have been received, facilitating the creation of new aggregations.