active projects trend graph
I'm trying to create a stacked graph that will show all active projects per months (eg. last 6 months), where I would include following: * all active projects 6 months ago, * then all active projec...
Forum Discussion
You need to create a second table that contains a monthly snapshot of your active projects. Use the table-to-table import function of Quickbase. Include fields to filter on (I.e, status) and the field that will be the series in the stacked bar chart. The date you do the import (your snapshot date) can be the x-axis in your stacked bar chart.
Hi Kevin, can you specify what you mean exactly when you say "snapshot of active projects"?
I understand the part regarding creating a table, and relationship, and maybe even lookup fields,... but could you clarify a bit more about what you mean?
I understand the part regarding creating a table, and relationship, and maybe even lookup fields,... but could you clarify a bit more about what you mean?