Hi All, We hope to implement a dashboard for BPS statistic data. We have listed some of graphs that can be generated process related events [1] and these events are divided into three categories called process level monitoring, task level monitoring and user level monitoring. As in the attachment [1] data visualized in graphs has to be filtered using a mandatory primary filter (if available) and optional secondary filters.
As an example, if we are analyzing the involvement of different users in a particular process, we have to provide the process ID as the primary filter. There can be a large number of users in the system which could result in too many entries in the X axis. To overcome this, most graphs have to provide a secondary filter to obtain only top X or bottom X entries (asc or dsc ordering). In addition, many graphs have to provide a secondary filter to restrict the analysis to a specific date range. We are using spark scripts to compute these process metrics in DAS. However, we need to change parameters of scripts at runtime (e.g. when a different date range is selected by a user, script has to be updated). a.) Is that possible in DAS side ? eg: SELECT processDefinitionId, COUNT(processInstanceId) AS processInstanceCount, AVG(duration) AS avgExecutionTime FROM BPMNProcessInstances WHERE date BETWEEN *"fromDate" *AND* "toDate" *GROUP BY processDefinitionId; (here *fromDate* and *toDate* are variables that need to be passed at runtime) b.) If not we can store the summarized data with primary and secondary filters which mentioned in [1] on DAS and then we can fetch them through DAS REST API by passing appropriate parameters. (According to the above given example in a. *fromDate* and *toDate* are no longer be variables in approach b. In this case all SPARK-SQL queries are static. ) [1] https://docs.google.com/a/wso2.com/spreadsheets/d/1pQAK6x4-rL-hQA7-NOaoT2llyjxv_nfc_vUarwUr74w/edit?usp=sharing -- Isuru Wijesinghe *Software Engineer* Mobile: 0710933706 [email protected]
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
