Jump to content
  • 0

Show Chart Graphs based on Table ID


Question

Hi all,


So.. I'm trying to create a Voting Best of Dining contest.

I have for my table fields:

id | date | fname | lname | email | best_taco | best_burger | best_pizza | best_coffee | best_sandwich | best_icecream | etc.. etc

Then for the form I have:

First Name:  __________

Last Name: __________

Email: _____________

Select Best Hamburger:  O 5GUYS   O In-N-Out  O Farmer Brothers  O Carls Jr   O White Castle

Select Best Sandwich:  O Subway   O Togos  O Lees  O Quiznos   O Arbys

etc

SUBMIT

 

What I need to do, and can't figure out.. is how to create a reports page using a chart or pie-graph that allows me to tab through all the table fields to see the count for each id/category.

So.. if I'm on the results page, I would want to select, or filter, "BEST HAMBURGERS" from a menu-list and a chart for all the entries shows up, with a count for each business name clearly shown.

Like this:
BEST HAMBURGERS TOTALS:

5Guys = 125
In-N-Out = 250
Farmers Brothers = 84
Carls Jr = 85
White Castle = 146

And a pie chart would show me the pie graph split into 5 pieces, with totals showing for each business name.

pie-sample.jpg

Then, I could select from the filter menu "BEST SANDWICH" and the displayed data and pie-chart then show for that category only.

 

Is this possible with the current app structure I have (shown above).. or would this be a much more involved setup?

 

Thanks for any and all help.

Geoff
 

Link to post
Share on other sites

0 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...