Dashboard with categories

Dashboard Designer
1

Hi.... I am just beginning to use the DesignerDashboard. I have a SharePoint list that contains a list of people with their place in the hiring process (ie. resume received, application completed, phone interview, initial interview, hiring manage interview, team interview, offer sent, offer accepted, hired, reported for work). I want a chart that shows the hiring process steps in the x-axis and each person's name on the y-axis. The chart could be a bar chart or a bubble chart that indicates which step of the hiring process each person is in.

I can only get my chart to show a numeric value in either the x-axis or the y-axis. Is there a way for me to configure the above scenario?

2

Hello @rhonda,

You can try creating a chart based on the Revenue distribution chart example from this post:

3

Hello Margo,

I had tried using that chart as a model. However, I get an error message "Rendering failed: Reference Error: getProcessByIndex is not defined." This happens when I added the X-axis and Y-axis values in the Label Template in the Chart Style area.

In the Data Source Advanced area, I have "window.data = data;" as the first line. Followed by

handlers.aggregationSuccess = function (data, logger){
var processes = ;
var persones = ;

window.getProcessByIndex = function(id){
  return processes[id] || '';
}
window.getPersonByIndex = function(id){
   return persons[id] || '';
}

......... more code like what is presented in the Example for this chart
}

I have a question though. The Example lists have the values for country and product category listed as lookups. My process field is a choice field. Does this change how the code should be written in Data Source > Advanced? I am thinking the Process field doesn't have an index value since it is a Choice and not a Lookup? I do not get any errors when I click Process button on the Data Source tab. The errors come when I try to call the getProcessByIndex function in the Chart > Style > X-axis label template or Chart > Style> Y-axis label template.

FYI, all data is coming from one list.

Thanks, Rhonda

4

@rhonda,

Please share a screenshot of the code and where it is added. Also, please share a screenshot of the errors from the browser console.