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

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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.
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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. 
Photo of Marc Nelson

Marc Nelson

  • 322 Points 250 badge 2x thumb
That worked mostly. I figured out the relationship in order to get a graph to show how many. There are dates on table 2 and I can not figure out how to get the quantity of records with the option of certain dates.

Thanks for the help!
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Can you describe the type of date filters you are looking for?  Maybe I can help point you in the right direction.