Need a dashboard of some kind for our Project Leads that automatically shows a separate gauge(or bar) chart for only those projects that he/she is the lead of.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
On the Project form there is a drop down where we select the project lead.  I need a way to have a dashboard of some kind that when, for example, John Doe logs into his QuickBase account he sees a separate gauge report for each project he is the lead on and they would all be on the same page.    

I know I can make one gauge report and embed it into the Project form, which would then show up as a unique report when clicking into each project record, but how do I get them to show all together and only show the ones that belong to each respective project lead?
Photo of Robin K

Robin K

  • 70 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
You only need one report/chart. Just filter the data with the criteria:

[Project Lead] "is the current user"
Photo of Robin K

Robin K

  • 70 Points
Sorry Dan that's not quite what I'm after.   If Mike Smith logs into QuickBase and he is the project lead on 5 projects, how do I make a single dashboard page such that a separate gauge report for each of the five projects shows up all next to each other on the same page?  Note that I will not be making a report for each project.  It has to be automatic.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
If you want multiple charts you still use the above query but using the API method ?act=API_DoQuery. Then you parse the XML response using script and then use jQuery and Underscore to generate the options for a set of custom HighChart - one per project. Gauges only take a single number a few parameters to define the scale and appearance so this is quite easy to do. See this Highchart demo:

http://www.highcharts.com/demo/gauge-solid

The details depend on your particular table and field structure but the process is quite easy to do with script. One question I still have is how a gauge chart (which typically represents a number like RPM or temperature) or even a bar chart adequately represent the status of a project which normally would involve displaying a date or status value. You have to use script to generate these charts as you need some type of looping mechanism the generate one chart per project.

In any event if you need individualized help with this feel free to contact me off-world using the information in my profile.