Skip to content
Security incidents
The Summary Table aggregates all of the individual items from the Data table
You should have one row for each Priority level in this table
Incidents Summary Table
Priority
Count
Template
All Data Items
Order
P0
1
Red Callout
New wave of DOS attacks
1
P1
0
Orange Callout
2
P2
0
Yellow Callout
3
P3
0
Blue Callout
4
There are no rows in this table
The Data Table is your granular data from your source
This is each individual report or record with a Priority assigned.
Incidents Data Table
Title
Description
Assigned to
Priority
Status
Incident doc
New wave of DOS attacks
We are seeing a flood of requests on our API endpoint /users
P0
In progress
There are no rows in this table
Showing a bulleted list ticket counts by priority level
We go through each row in the Summary Table and for each one, we Concatenate() the Priority level as the label and the count of rows from the data table as the value.
If the count is greater than 0, we hyperlink the number to the row modal popup to show the details.
The following formula needs to be added to the respective “Content” field in the table
[Incidents Summary Table].ForEach(
Concatenate(
CurrentValue.Priority.ToText(),":",_Bold(" "),
If(
CurrentValue.Count = 0,
0,
Hyperlink(
Concatenate(CurrentValue.ObjectLink(),"&view=modal"),
CurrentValue.Count.ToText()
)
)
)
).Join(LineBreak())
The callout below is a formula that can be placed on the page
Format(
If(
[Incidents Summary Table].Count.Sum() = 0,
[Steady State].Template,
[Incidents Summary Table].Filter(
Count > 0
).MinBy(Order).Template.Template
),
// @reference the respective row from Dashboard Sections and use the Content Combined column
Incidents.[Content Combined]
)
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.