Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
4 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
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
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's avatar
AlexBennett3
Qrew Trainee
4 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
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    Unfortunately, this is the downside of building all of this on a single Schedules table. If you are capturing the same information for each Dept/Phase combination, it's better to set that up as a single record and use the built-in Summary fields to calculate any totals that you may need. Essentially, you would end up with quite a few more tables, but your application would be structured for growth.

    So, essentially, you need a structure similar to this:
    In about 30 minutes, I put together an example application with the following tables:

    And produced this:




    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • AlexBennett3's avatar
      AlexBennett3
      Qrew Trainee
      4 years ago
      So If I only have 2 Tables being Jobs and Schedules, how hard would this be to convert over to split these up? When all my data on Schedules is either being Lookup fields, and formula fields calculating these fields for totals. Now that I have this built out I'm not sure how to go about breaking it up without just restarting completely. I do appreciate your help and input though! Thank you!

      ------------------------------
      Alex Bennett
      ------------------------------
      • AlexBennett3's avatar
        AlexBennett3
        Qrew Trainee
        4 years ago
        Is there a way I can break up my current table to get this? I'm a little confused on my options for moving forward. So If I'm understanding correctly, not only would I have to split up each Department for that 1 job into individual records, but If I want to show duration by phase for each department I'd have to split those up too? So Id have up to 28 individual records for 1 job?

        ------------------------------
        Alex Bennett
        ------------------------------