I have a form where you can choose a value, a time frame and click Search. The search will run and display a bar graph and table of the results.
The bar graph and table currently are only displaying about a weeks worth of data no matter what time frame you choose. For example, I choose 30 days, I still only get a week graphed and tabled.
However if I click on the "View Results" link under the table or graph, I can see all of the results for the time period specified. Example: Click View Results for 30 days, see 30 days of data graphed and 30 days of data tabled.
How can I get the graph and table to display the right amount of data for the time period I specify on the form? I'm not using timechart and I'm wondering is this the issue? I looked at other forms and some weren't using timechart at all. Here's my code from my form.
asked 25 Jan '12, 12:30
well I sorta answered my own question. timechart was the answer.
I changed my search in the form to this:
I was then able to see results for large spans of time. Now I just need to calculate an average time in MS for each field instead of a sum. Onward!
answered 27 Jan '12, 13:20