AnsweredAssumed Answered

Help with Data Series via Related Tables

Question asked by ErickJ.Gonzalez on Jan 6, 2016
Latest reply on Jan 13, 2016 by mikebeargie

FMpro14

I am new to dashboards and as a learning project I have created a dashboard that currently has 2 column charts:

Chart1 - shows the number of screeners submitted to us by school district

and

Chart2 - shows the number of students approved for services (as a result of the screeners)  by school district.


I would like to have one chart that combines the previously mentioned 2 charts.

so the "x" axis shows the 4 school districts

and

the "y" axis shows the number of screeners submitted along with the number of students approved for services (2columns for each school).

i.e:

School District 1 submitted 130 screeners (1st column) and as a result 15 students were found eligible for services (2nd column)

School District 2 submitted 85 screeners (1st column) and as a result 27 students were found eligible for services (2nd column)

School District 3 submitted 58 screeners (1st column) and as a result 19 students were found eligible for services (2nd column)

School District 4 submitted 180 screeners (1st column) and as a result 41 students were found eligible for services (2nd column)

Relationships.jpg

Outcomes