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

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
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 bar graph. I've got most of the way there but I have 2 problems. Firstly is there a way I can have an input on the same page as the report that allows you to choose the date range to plot. Secondly, my y-values for total print time are currently displaying in decimal, where the data being pulled from the table is a duration data type, can I display axis labels in hours and minutes instead of the current numeric type?

Thanks for any help!
Photo of Max Allen

Max Allen

  • 302 Points 250 badge 2x thumb

Posted 6 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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.
Photo of Max Allen

Max Allen

  • 302 Points 250 badge 2x thumb
Thanks for the help! I went about this in a different way in the end and thought I'd post.  It was just case of adding two filters to the data series on the report:

1. On or before the date <ask the user>
2. On or after the date <ask the user>

My problem before is I was trying to find a way to do it with one filter.