Historical info for line chart.
Hey Everyone, I wanted to see If I could get some input on some options for QuickBase, so that I can change my code to accommodate these new data points. I have a Line Chart that displays a jo...
Forum Discussion
If you want to see change over time, you will have to capture that historical data in another table and build the reports on that table.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
But from my understanding, I'll have to have a record for every point of data to display on my Custom Coded Line Chart correct? I just don't see any other way. For example, if I want to get a weekly current for that job to display on the code, I'd need a field to reference from for the code. So if I have 50+ jobs, each going from 3 months to 5 years in length, I'd end up having a million records created to be able to display that data?
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
- MarkShnier__You
Qrew Legend
You would need a record created for each weekly snapshot. An Automaton would run a saved Table to table copy each weekend to copy the jobs into the History table. But you would only copy a few fields that you need for the charts and they can be children of the job, so you don't need to copy any fields that can be looked up, like [Job Name].
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
