- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need Help: Average the % gas fills by each Department.
Hello.
I am trying to calculate an average fill percentage for each area for gas deliveries. I cannot seem to find a solution to this anywhere. I would appreciate any guidance on this. Screenshot below. Thank you!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi everyone.
I am trying to calculate an average fill percentage for each area's gas deliveries. I cannot seem to find a solution to this anywhere. I would appreciate any guidance on this. Data table is below. Please let me know if there is additional information needed. Thank you!!
1. Show average %Filled broken down by AREA in a time period.
2. Be able to show all of the TOTAL % FILLS that are below the Target of 60%. Again, broken down by area.
Thank you for your time.
Area | Account No | Submission No | Sequence by Account no | FillDate | Assigned Fill Frequency (Days) | Frequency Variance (Days) | Total Tanks Capacity | Total Quantity Delivered | Total % Filled | Fill Target % | Fill Target Variance (% points) |
E101 | 8018879 | SN4177028 | 0 | 1/20/2022 | 35 | -35 | 750 | 373 | 50% | 60% | -10 |
E101 | 8018879 | SN4198336 | 1 | 2/12/2022 | 35 | -12 | 750 | 399 | 53% | 60% | -7 |
E101 | 8018879 | SN4228695 | 2 | 3/16/2022 | 35 | -3 | 750 | 371 | 49% | 60% | -11 |
E101 | 8018879 | SN4255589 | 3 | 4/13/2022 | 35 | -7 | 750 | 205 | 27% | 60% | -33 |
C101 | 8023107 | SN4297848 | 0 | 5/26/2022 | 98 | -98 | 12000 | 2005 | 17% | 60% | -43 |
C101 | 8023107 | SN4357194 | 1 | 7/27/2022 | 98 | -36 | 12000 | 2274 | 19% | 60% | -41 |
W101 | 8023527 | SN4177421 | 0 | 1/20/2022 | 21 | -21 | 6600 | 3972 | 60% | 60% | 0 |
W101 | 8023527 | SN4187176 | 1 | 1/31/2022 | 21 | -10 | 6600 | 2458 | 37% | 60% | -23 |
W101 | 8023527 | SN4206944 | 2 | 2/22/2022 | 21 | 1 | 6600 | 4040 | 61% | 60% | 1 |
E102 | 8025005 | SN4206612 | 0 | 2/21/2022 | 28 | -28 | 4000 | 3065 | 77% | 60% | 17 |
E102 | 8025005 | SN4318232 | 1 | 6/16/2022 | 28 | 87 | 4000 | 4260 | 107% | 60% | 47 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi @FOZZY
you may get a solution quicker if you paste your sample data as text.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry for the delay in response. Below is a sample of the data. What I am looking to do in visuals is
1. Show average percent fill amount per area in a time period determined by a slicer.
2. Be able to show all of the Total % fills that are below the Target %. Broken down by area.
Thank you for your time.
Area | Account No | Submission No | Sequence by Account no | FillDate | Assigned Fill Frequency (Days) | Frequency Variance (Days) | Total Tanks Capacity | Total Quantity Delivered | Total % Filled | Fill Target % | Fill Target Variance (% points) |
E101 | 8018879 | SN4177028 | 0 | 1/20/2022 | 35 | -35 | 750 | 373 | 50% | 60% | -10 |
E101 | 8018879 | SN4198336 | 1 | 2/12/2022 | 35 | -12 | 750 | 399 | 53% | 60% | -7 |
E101 | 8018879 | SN4228695 | 2 | 3/16/2022 | 35 | -3 | 750 | 371 | 49% | 60% | -11 |
E101 | 8018879 | SN4255589 | 3 | 4/13/2022 | 35 | -7 | 750 | 205 | 27% | 60% | -33 |
C101 | 8023107 | SN4297848 | 0 | 5/26/2022 | 98 | -98 | 12000 | 2005 | 17% | 60% | -43 |
C101 | 8023107 | SN4357194 | 1 | 7/27/2022 | 98 | -36 | 12000 | 2274 | 19% | 60% | -41 |
W101 | 8023527 | SN4177421 | 0 | 1/20/2022 | 21 | -21 | 6600 | 3972 | 60% | 60% | 0 |
W101 | 8023527 | SN4187176 | 1 | 1/31/2022 | 21 | -10 | 6600 | 2458 | 37% | 60% | -23 |
W101 | 8023527 | SN4206944 | 2 | 2/22/2022 | 21 | 1 | 6600 | 4040 | 61% | 60% | 1 |
E102 | 8025005 | SN4206612 | 0 | 2/21/2022 | 28 | -28 | 4000 | 3065 | 77% | 60% | 17 |
E102 | 8025005 | SN4318232 | 1 | 6/16/2022 | 28 | 87 | 4000 | 4260 | 107% | 60% | 47 |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-04-2024 10:55 PM | |||
Anonymous
| 06-02-2023 12:14 AM | ||
07-08-2024 03:34 AM | |||
03-19-2024 12:14 PM | |||
03-02-2023 09:52 AM |
User | Count |
---|---|
14 | |
13 | |
10 | |
10 | |
8 |
User | Count |
---|---|
19 | |
17 | |
14 | |
13 | |
11 |