BloX - Executive Dashboard Example
Article Topics:
- Tabs to switch between dashboards
- Indicators + Conditional Formatting
- Switch between widgets- Including modeling solution (Alternative for Tabber plugin)

Tabs to switch between dashboards:
Add an action type "jump to dashboard" - the new dashboard will open within the current tab

{
"type": "ActionSet",
"actions": [
{
"type": "JTD",
"title": "Dashboard 1",
"data": {
"dashboardId": "5e8ad317dcb7732288a129da",
"panelsToInclude": [],
"args": {
"displayDashboardsPane": false,
"displayFilterPane": true,
"drilledDashboardDisplayType": 3
}
}
}
]
}
The "drilledDashboardDisplayType" parameter determines if the new page opens in the same window, new tab, or lightbox modal. Read more about this parameter in the jump to dashboard official documentation.
Indicators + Conditional Formatting:

1. Add Value with the condition, using CASE WHEN and Name it "Color1":
case when ([Total Cost]) > 950000 then 1 else 0 end

2. Change the "contatingerStyles" in the configuration tab based on the condition:
"1": {
"normal": "#dd1111"
}

3. Add a TextBlock - use "color" : "{value:Color1}" to apply the color conditional formatting

{
"type": "Column",
"items": [
{
"type": "TextBlock",
"spacing": "medium",
"text": "Sales",
"color": "grey",
"size": "extraLarge",
"horizontalAlignment": "center",
"weight": "default"
},
{
"type": "TextBlock",
"spacing": "medium",
"text": "{panel:Sales}$",
"color": "{value:Color1}",
"horizontalAlignment": "center",
"weight": "center",
"size": "large"
}
]
}
Switch between widgets (Including modeling solution):

1. Add the relevant Filter buttons:

{
"type": "Filters",
"title": "Days",
"data": {
"filters": [
{
"filterName": "WidgetType",
"filterJaql": {
"explicit": true,
"userMultiSelect": false,
"multiSelection": false,
"members": [
"Days"
]
}
}
]
}
}
2. Add a TextBlock and change the the "src" to the relevant dashboard URL and replace the widgetID with {panel:widgetID}
{
"type": "TextBlock",
"id": "",
"class": "",
"text": "<iframe src='https://10.122.10.132/app/main#/dashboards/5e8b54e92f58dd2294029d28/widgets/{panel:widgetID}?embed=true&r=false&l=false&t=false&h=false' width='100%' height='600' style='border:none;overflow:hidden'></iframe>"
}
3. Create a new table in your data model using this SQL or as a CSV file and map the relevant widgetIDs to the filter name & EC build changes only:
select 'Days' as WidgetType , '5e8b54e92f58dd2294029d29' as widgetID
union
select 'Week' , '5e8b55012f58dd2294029d35'
union
select 'Month' , '5e8b55042f58dd2294029d37'

4. Add "WidgetType" column as a filter:

Attachments:
1. Main Dashboard - 1stexample.dash
2. Line chart widgets to switch - WidgetSwitch-1stexample.dash
Updated 03-02-2023
intapiuser
Admin
Joined December 15, 2022