Skip to main content

I can’t figure this out:


It’s about a voting system to vote for songs a specific artist should play on a specific event/date.


I need to gather and visualize a chart with these votes for each event/date.



I can get record entries in a table “Votes”.


A “Vote” has 10 columns for 10 questions that can be 0 or 1.


It also contains a name, date and can be linked to an “Event”



The other table is called “Events”.


An “Event” is bound to a Date and typically only has one artist.


I need to sum up all votes per event.



In a 3rd table i have the “Artists”.


Each artist has 10 values for the questions, which contain specific song_names for that artist.


So voting for Event A with artist B will have different voting values (read = song titles) than voting for Event B with artist C.



So i just get 1 or 0 values in a “Vote”-record.


Most important is that i can get this:





  • an overview of votes for a specific event, which results i can limit within a date range


  • it should be in a chart with on x-axis the 10 names of the songs that are linked to the event/artist


  • on the y-axis the amount of votes (within a date-range ideally)




I know all the data is in the tables, but i have no idea how to combine this to get one good (bar)chart.



Visual Data Graph/Map:


PS. the structure of Events and Artists can change if needed.


But the table for Votes will have 10 columns with the true/false (or 1/0) values - that’s the input i get from Webflow/Zapier)



ALTERNATIVE OPTION:



Also possible is to work without Events, and only have Votes linked to Artists.


Combining votes with date-range can solve this to tie them to a specific Event, if needed.

PS. the structure of Events and Artists can change if needed.


But the table for Votes will have 10 columns with the true/false (or 1/0) values - that’s the input i get from Webflow/Zapier)



ALTERNATIVE OPTION:



Also possible is to work without Events, and only have Votes linked to Artists.


Combining votes with date-range can solve this to tie them to a specific Event, if needed.


Simpler question perhaps, related to same as above.


How can i set out a xy chart, with values of 1 record/row.



I now have 10 answers/vote, and i have 10 dynamically looked-up titles for these questions.


So i want to create a chart of values, and the names on the x-axis (question 1, question 2, etc.) should be replaced/renamed to the values of the 10 titles - all in the same record.

Reply


Terms & Conditions