What is the Best Approach to a Summary Table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

My requirement is to create a report so that I have stores listed down the left hand side and a few columns on the top row and I have traffic lights in the middle. The rows at the top will be calculated fields  testing certain against a criteria such as weeks to start on site. 

The first question is if this going to be a summary report, can I use a number of fields in the top row and does it have to be a variant of a drop down field.  If not, is it possible to create a crosstab sort of report in the normal report. 

My fields are based on a single table. 

I have attached a sample of report.   Will appreciate some insight.    

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
For traffic lights (icons) you will not be able to use a Summary Report.  You will need to have a regular Table report of the Stores and text formulas to calculate the icons based on data on the Stores records.  That data can include aspects like # projects which are on time or % of projects which are on time or on budget.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks a lot.  I managed to figure out and it is working well.