Scheduling Capacity Chart
Hi All, I have a Stores table that contains all the data for my stores, including the Delivery/Install date for the equipment we're installing. I'm trying to create a stacked bar chart that show...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI think you are on the right track. Set up a table of weekly capacities where the key field of the table is a date field and the date is the first Sunday of the week. You can do this in excel and import the next 10 years of Sundays.
Then on your installation schedule record you can make a formula for the first day of the week
FirstDayOfWeek(Install date])
Take a relationship where one weekly capacity has many installations and use that first day of week field as the reference field in your installations child table.
No I cannot think of a way to get the first to look exactly like you have them but you could have a formula field that shows the percent of full capacity which is the number of installations divided by the capacity expressed as a percent. Then the bars could indicate how close they are below or above 100%.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Then on your installation schedule record you can make a formula for the first day of the week
FirstDayOfWeek(Install date])
Take a relationship where one weekly capacity has many installations and use that first day of week field as the reference field in your installations child table.
No I cannot think of a way to get the first to look exactly like you have them but you could have a formula field that shows the percent of full capacity which is the number of installations divided by the capacity expressed as a percent. Then the bars could indicate how close they are below or above 100%.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------