Discussions

Expand all | Collapse all

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

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

    Posted 06-20-2018 07:49
    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!


  • 2.  RE: Creating a report with a dynamic x-range & displaying duration y-values

    Posted 06-20-2018 12:09
    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.


  • 3.  RE: Creating a report with a dynamic x-range & displaying duration y-values

    Posted 06-20-2018 14:17
    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.