Forum Discussion

Qrew Trainee

5 years ago

Timeline Report / Calendar Report

Hey Everyone, I had some questions about these reports to help understand my limitations... I have an app that takes Job data for 7 different departments tied to that Job, and I've estimated how...

reports and charts

Qrew Captain

5 years ago

Unfortunately, not the way that you have it structured. The Timeline Report (Gantt) utilizes individual records with a Start and End date.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------

AlexBennett3
Qrew Trainee
5 years ago
So I would have to break up my Job record with all the data into multiple to be able to show all of them up on a Timeline Report?

------------------------------
Alex Bennett
------------------------------
- BlakeHarrison
  Qrew Captain
  5 years ago
  If you want to show the Start / End time for each Department on a Timeline report, each Department would have to have be a child record to the Job and your report would be done on that child table.
  
  ------------------------------
  Blake Harrison
  bharrison@datablender.io
  DataBlender - Quick Base Solution Provider
  Atlanta GA
  404.800.1702 / http://datablender.io/
  ------------------------------
  - AlexBennett3
    Qrew Trainee
    5 years ago
    
    So this is the layout of my app, there are 7 departments that I'm trying to display on a calendar or timeline to visually display their durations in 4 phases. Right now this Schedules table is a child of my Jobs table. So you're saying I'll have to Split each department into separate records? If so, how would I display all the records needed separately on a Timeline Report?
    
    ------------------------------
    Alex Bennett
    ------------------------------