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'