sharing the problem statement of Statistics Report dashboard
1. 1. We have different Types of logs based on different types of events of multiple micro services of multiple environment.
2. 2. We have different set of words to identify types of events, micro services name and their hosted environment name
3. So we are looking for the query that generate the reports as per custom defined threshold and It should be looks like as per the attached excel sheets
Time | Micro service | Application Event Type | Count | | Micro service | Application Event Type | Count |
| ABC | System error | | | ABC | System error | |
| ABC | application error | | | ABC | application error | |
| ABC | successfully transaction | | | ABC | successfully transaction | |
| XYZ | System error | | | XYZ | System error | |
| XYZ | application error | | | XYZ | application error | |
| XYZ | successfully transaction | | | XYZ | successfully transaction | |
· We have been using regex concepts to create two fields named as “Micro service” and “Application event type”
· We are already using group by concepts of Time series and non-time series along with our custom fields.
Expected: Data should be fetched with exact number of counts and as per time interval
Actual: Data is not coming at all