Forum Discussion
RhondaParriet
Qrew Member
The fields need to be summed based on the month. Each of these "summed" fields are used in calculations to create a stacked bar chart showing values month over month for a specific machine.
I have one table with machines
---fields are department, machine
one table with the fields that are calculated by month.
Fields include machine, month, year, and the several formula fields
ex total breakdown/minutes ran
total quality / minutes ran
stop/minutes ran
The three above fields added together to make another field
In total there are 24 formula fields based on the input fields.
A third table will have these weekly inputs.
These fields are date (week-ending), machine, and the input fields
Breakdown, stoppage, quality, setup, tool, minutes ran
------------------------------
Rhonda Parriet
------------------------------
I have one table with machines
---fields are department, machine
one table with the fields that are calculated by month.
Fields include machine, month, year, and the several formula fields
ex total breakdown/minutes ran
total quality / minutes ran
stop/minutes ran
The three above fields added together to make another field
In total there are 24 formula fields based on the input fields.
A third table will have these weekly inputs.
These fields are date (week-ending), machine, and the input fields
Breakdown, stoppage, quality, setup, tool, minutes ran
------------------------------
Rhonda Parriet
------------------------------
AdamKeever1
5 years agoQrew Commander
Add a formula rich text field and create a formula to combine the date and machine like this:
Then you can graph on the combination of the year/month and machine (these are unique):
Here is what the graph looks like with some additional data added:
You can filter by machine:
You can also set a report filter to <ask user> for the machine or add the date to the dynamic filters list and select specific time periods. Month has to handled this way since charts order either ascending or descending so using the text for the month, such as November, would disorder the data in a chart since you cannot manually select the order. Also as you add data year over year, the data for multiple years of November would be charted in the same bar.
ToText(Year([Date]))&ToText(Month([Date]))&" - "&[Machine]​
Then you can graph on the combination of the year/month and machine (these are unique):
Here is what the graph looks like with some additional data added:
You can filter by machine:
You can also set a report filter to <ask user> for the machine or add the date to the dynamic filters list and select specific time periods. Month has to handled this way since charts order either ascending or descending so using the text for the month, such as November, would disorder the data in a chart since you cannot manually select the order. Also as you add data year over year, the data for multiple years of November would be charted in the same bar.
------------------------------
Adam Keever
------------------------------