Total as Series Option in Charts

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I am being constantly fed back on showing a total series  to compare progress of achievement in charts.  Isn't there any way to achieve this without resorting to some add ons?
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of David Maskasky

David Maskasky

  • 100 Points 100 badge 2x thumb
Hi Arshad,

I hope I am interpreting your question correctly.  If not, please let me know, I will do my best to give you a better answer.

Typically when I need a report of some aggregate measure, I find that it is much simpler to transform the data and push it into another table.  Sometimes, there are cases where a periodic push is not an option, such as when I need to view live or transactional reports.  In those cases, I would add a little Javascript to the page to submit a transformed copy of the record to this second table on submit.

Here is an example of where I do this.  At my company, I log every action by every user in our realm.  Every time the page loads or a user submits an asynchronous request, they add a record to a table called Server Logs.  This record captures who they are, what page they were on, the timestamp, and so on.  I have a report where I can see the number of page loads by application in the realm for any given day.  This is only of limited use however, because it doesn't give me an idea of how many users accessed each application on any given day.  There is simply not a way to aggregate this in a Quickbase stacked bar report.  So this is the reason for a second table.


In the second table called User Logs, the user submits one record for every application they have logged in to that day.  So now this aggregate bar report is easy.  From there I can gain a new insight into which users are loading lots of pages in an application, which helps in providing better administrative insights.

I hope this helps.

 Best regards,

David Maskasky
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks David for kindly describing your situation.  I am trying to relate to my situation but still little uncertain.  We have a program of several projects which have different development types and open at varying time of the year.   So the requirement is that we report how many projects were there in total and then compare these with the bars showing total completed in each development type.  So trying to make a chart which additionally shows a series covering the total number of projects.  Now relating to your scenario, do I still need a separate table to keep counts? If so, how best to summarise the info and then add to a table.  I find it little daunting but some hand holding will help.
Photo of David Maskasky

David Maskasky

  • 100 Points 100 badge 2x thumb
Can we get on a webex call to solve this?  I would need to see in person better understand.