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 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'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. 
  • MarcNelson's avatar
    MarcNelson
    Qrew Cadet
    8 years ago
    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!
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    Can you describe the type of date filters you are looking for?  Maybe I can help point you in the right direction.