Skip to main content
Question

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

  • June 20, 2018
  • 0 replies
  • 51 views
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!
    This topic has been closed for replies.

    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
    • Author
    • Registered
    • June 20, 2018
    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.
    Terms & ConditionsAccessibility statement