Forum Discussion

MarcNelson's avatar
MarcNelson
Qrew Cadet
8 years ago

Can you predefine the x axis of a bar graph based on values of another table?

I have a list of 10 people in table 1. In Table 2, I am able to add a record that is linked to a person on table 1. I want to be able to have a bar graph (any graph really) that will show all 10 peopl...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
If you are using totals or some type of numeric value on the graph, I'd recommend building the graph on the "People" table.

For example if you are trying to show the # of x for each resource, you will want to summarize that value to the people table, and then build the report from that table.  And any time they have '0' it will still show.

Does that make sense?  Rather than building the report on the child table, summarize the data to the parent and build the report there.