AnsweredAssumed Answered

Help: Drop down menu values connected to three other variables

Question asked by RockyGor on Jun 23, 2015
Latest reply on Jun 25, 2015 by philmodjunk

Title

Help: Drop down menu values connected to three other variables

Post

I am trying to track a restaurant's performance over a period of 7 days for three services, i.e breakfast, lunch and dinner.

- There is a drop down menu to select the service from three possible values - breakfast, lunch, dinner

- Numeric variable field # 1 for number of customers - to be manually populated daily

- Numeric variable field # 2 for number of servers -  to be manually populated daily

- Numeric variable field # 3 for number of total revenues per service -  to be manually populated daily

As this will be tracked over seven days, there will be 21 (3 sets for 3 services per day for seven day) sets of records. 

Question: what do I need to do to connect each individual data set for a specific day and specific service. E.g. on Monday, for breakfast, we had 25 customers, 3 servers and $500 of revenues.

Thanks for your suggestions!

 

Outcomes