Forum Discussion

MaxAllen's avatar
MaxAllen
Qrew Cadet
7 years ago

Creating a report with a dynamic x-range & displaying duration y-values

I have a table "Print Requests" where each Print Request has an Estimated Duration and an Estimated Print Date. I want to create a report that shows the total estimated print duration on each day as a...
reports and charts
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I will answer the first part.

Make a single table with a single record called Set Chart Range. In that single record, which will be [Record ID#] = 1 make the fields for the date range.

Then on the details table, make a field called [link to Set Date Range (=1)] and have the formula be

1

Then make a relationship based in that field back to the date Range Table and out the chart in the record as a Report link field. The chart will use the lookup values for the date start stop.