Skip to content

sample-incident-analytics

Pipeline: sample-incident-analytics

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
## Load dataset
@dm:recall
            name="sample-servicenow-incidents"
    --> @dm:save
            name="temp-incidents"

## Analytic-1: Top 3 Categories
--> @c:new-block
        name="Top-3 Categories"
    --> @dm:recall
            name="temp-incidents"
    --> @dm:groupby
            columns="category"
    --> @dm:sort
            columns = "number" & order = 'descending'
    --> @dm:head
            n=3

## Analytic-2: NLP Insights
--> @c:new-block
        name="NLP Insights"
    --> @dm:recall
            name="temp-incidents"
    --> @nlp:extract-keywords
            description_col = "description"
    --> @nlp:extract-named-entities
            description_col = "description"

## Generate CSV file and save to local filesystem
--> @c:new-block
        name="Generate CSV Report"
    --> @dm:recall
            name="temp-incidents"
    --> @files:savefile
            filename="sample-incidents-report.csv"

## Generate HTML Report and save to local filesystem
--> @c:new-block
        name="Generate HTML Report"
    --> @dm:recall
            name="temp-incidents"
    --> @dm:apply-template-all-rows
            template_name = "sample-incident-html-template" & output_col = "message"
    --> @files:savefile
            filename="sample-incidents-report.html"

Playground

Try this in RDA Playground


Extensions used in this Pipeline

Source Name Extension Type
nlp cfxai_nlp
files file


Artifacts used in this Pipeline

Artifact Type Artifact Name Access
dataset sample-servicenow-incidents read
formatting-template sample-incident-html-template read


Bots used in this Pipeline

@dm:recall @dm:save @c:new-block @dm:groupby @dm:sort @dm:head @nlp:extract-keywords @nlp:extract-named-entities @files:savefile @dm:apply-template-all-rows