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

Question

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 people from table 1 and then the quantity of records on table 2. Ex, If I am on table 1 but there are no records on table 2 linked to me, I want my name to show up on the graph with 0 records. I hope that makes sense.

MCFNeil · Answer

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.

Sign up

Login to the community