cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Article Topics:
  • Tabs to switch between dashboards
  • Indicators + Conditional Formatting
  • Switch between widgets- Including modeling solution (Alternative for Tabber plugin)
Screenshot_4.png

Tabs to switch between dashboards:

Add an action type "jump to dashboard" - the new dashboard will open within the current tab 
Screenshot_6.png
{
 "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:

Screenshot_7.png
1. Add Value with the condition, using CASE WHEN and Name it "Color1":
case when ([Total Cost]) > 950000 then 1 else 0 end
Screenshot_11.png
2. Change the "contatingerStyles" in the configuration tab based on the condition:
"1": {
 "normal": "#dd1111"
 }
Screenshot_12.png
3. Add a TextBlock - use "color" : "{value:Color1}" to apply the color conditional formatting
Screenshot_7.png
{
 "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):

Screenshot_13.png
1. Add the relevant Filter buttons:
Screenshot_15.png
{
 "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
Version history
Last update:
‎03-02-2023 08:48 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: