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 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!
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.
  • MaxAllen's avatar
    MaxAllen
    Qrew Cadet
    7 years ago
    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.