Jump to content
  • 0

Show Chart Graphs based on Table ID


geoffdude
 Share

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 comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi Geoffdude,

 

 

Capture.PNG

Screenshot (3).png

Link to comment
Share on other sites

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...
 Share

×
×
  • Create New...