Build It, Dream It: Self-Service Dashboard

September 12, 2019 Jeff Hainsworth

 

By popular request, this video provides a step-by-step walk-through on how to build an a-la-carte style self-service dashboard for your users in Dundas BI. It is expected in this video that you already understand the basics of Dundas BI before proceeding.

If you're interested in using the scripts I've used in the video, feel free to acquire them from below: 

script 1: - Data Table - On Click

// Hit test the table to see what was clicked
var args = dundas.Utility.getAdapterHitTestArguments(e.originalEvent, table1);
var rowIndex = table1.control.hitTest(args.offsetX, args.offsetY, args.target).rowIndex;
var dashboardName = table1.metricSetBindings[0].dataResult.cellset.rows[rowIndex].members[0].caption;
var dashboardId = table1.metricSetBindings[0].dataResult.cellset.rows[rowIndex].members[1].caption;

// Update the parameter to save what was selected
var canvasService = this.getService("CanvasService");
var viewParameter = canvasService.canvasAdapter.control.viewParameters[window.selectedPanel]; 

// Use the stored 'Selected Panel' to determine the parameter to set
viewParameter.parameterValue.values[0].uniqueName = dashboardId+".Id";
viewParameter.refreshAllAdapters();
viewParameter.invalidateParameterValueLastModifiedTime();

Script 2: Data Label - On Data Changed

var dashboardId = this.metricSetBindings[0].dataResult.cellset.rows[0].members[1].caption;
dashboardId = dashboardId.toLowerCase();  

// Needed otherwise the SubCanvasViewContainer, fails to load.
subCanvasViewContainer1.setTarget(dashboardId, dundas.entities.ViewType.DASHBOARD);

Script 3: Ready Interaction

subCanvasViewContainer1.loadData();
subCanvasViewContainer2.loadData()

 

About the Author

Jeff Hainsworth

Jeff Hainsworth is a Senior Solutions Architect at Dundas Data Visualization with over a decade and a half of experience in Business Intelligence. He has a passion for building, coding and everything visual – you know, shiny things! Check out "Off the Charts... with Jeff", his platform for great content on all things analytics, data visualizations, dashboards, and business intelligence. There’s something for everyone!

More Content by Jeff Hainsworth
Previous Success Story
How Yulista Slashed Their Budgeting Time from 2 Weeks to 2 Hours
How Yulista Slashed Their Budgeting Time from 2 Weeks to 2 Hours

Next Blog
3 Data Storage Techniques in Dundas BI
3 Data Storage Techniques in Dundas BI

When it comes to business intelligence (BI) tools and the way they work with data, there are three main dat...

×

Request a Live Demo of Dundas BI

First Name
Last Name
Company Name
Phone Number
Country
I consent to receive commercial electronic messages from Dundas regarding products, services, updates and other information about Dundas. You can withdraw your consent at any time.
I Agree
Thank you!
Error - something went wrong!