Requirement
In this article, we will look to create a personalized dashboard navigation landing page that shows:
- The logged user's most popular dashboards.
- Most popular dashboards on the company level.
Consider further enhancing the logic presented in this article.
Solution
Steps:
1) To address the need, we will first need to learn how to implement a landing page - Follow this article to learn more on that.
The reasoning behind it is we will use data-security where we will give a logged user permissions to see:
- His own records - Retrieving his popular dashboards
- The dummy user records - Retrieving the most popular dashboards on a company level.
4) Add data-security rules to the model that enables the user to see his own UserID/UserName from DimUsers table + UserId/UserName '-1'.
5) Find the attached BloX template that introduced action buttons to jump to a specific dashboard.
LandingPage.json:
{
"card": {
"style": "",
"script": "",
"title": "",
"showCarousel": false,
"body": [
{
"spacing": "",
"type": "Container",
"items": [
{
"type": "TextBlock",
"text": "{panel:Dashboard Name}",
"horizontalAlignment": "center",
"size": "medium",
"style": {
"color": "#117899"
}
},
{
"spacing": "small",
"type": "TextBlock",
"text": "{panel:Total Column} # of Actions",
"color": "default",
"horizontalAlignment": "center"
}
]
}
],
"actions": [
{
"type": "Action.OpenUrl",
"title": "{panel:Dashboard Name}",
}
]
},
"config": {
"fontFamily": "Open Sans",
"fontSizes": {
"default": 16,
"small": 12,
"medium": 22,
"large": 32,
"extraLarge": 50
},
"fontWeights": {
"default": 500,
"light": 100,
"bold": 1000
},
"containerStyles": {
"default": {
"backgroundColor": "lightgrey",
"foregroundColors": {
"default": {
"normal": "#3A4356"
},
"white": {
"normal": "#ffff"
},
"grey": {
"normal": "#5C6372"
},
"orange": {
"normal": "#f2B900"
},
"yellow": {
"normal": "#ffcb05"
},
"black": {
"normal": "#000000"
},
"lightGreen": {
"normal": "#3ADCCA"
},
"green": {
"normal": "#54a254"
},
"red": {
"normal": "#dd1111"
},
"accent": {
"normal": "#2E89FC"
},
"good": {
"normal": "#54a254"
},
"warning": {
"normal": "#e69500"
},
"attention": {
"normal": "#cc3300"
}
}
}
},
"imageSizes": {
"default": 40,
"small": 40,
"medium": 80,
"large": 160
},
"imageSet": {
"imageSize": "medium",
"maxImageHeight": 100
},
"actions": {
"color": "",
"backgroundColor": "#10a5F5",
"maxActions": 5,
"spacing": "small",
"buttonSpacing": 20,
"actionsOrientation": "horizontal",
"actionAlignment": "center",
"showCard": {
"actionMode": "inline",
"inlineTopMargin": 16,
"style": "default"
}
},
"spacing": {
"default": 5,
"small": 20,
"medium": 40,
"large": 60,
"extraLarge": 40,
"padding": 25
},
"separator": {
"lineThickness": 1,
"lineColor": "#eeeeee"
},
"factSet": {
"title": {
"size": "default",
"color": "default",
"weight": "bold",
"warp": true
},
"value": {
"size": "default",
"color": "default",
"weight": "default",
"warp": true
},
"spacing": 20
},
"supportsInteractivity": true,
"height": 842,
"imageBaseUrl": ""
}
}
6) Import the attached dashboard example NavigationDashboard (1).dash.
You can learn more on how to customize BloX in the following documentation page: https://www.sisense.com/marketplace/blox-widgets/
That's it!
