Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I receive a file from a customer with all of their store sites listed and the tank volumes in each tank. the sites vary in the following:
1. Product Types
2. Tank Sizes
3. Tank Configuration
4. Maximum Volume
5. Current volume
What I would like to do is build a QV application that would scan all the site data and report when when the following conditions are true:
1. UNL tanks have a volume level of at, or below 4000 gallons
2. Premium Tanks have a volume at, or greater than 3000 gallons
3. Diesel Tanks that are at, or greater than 3000 gallons
I would like to build this application to be a button driven application, as this file is all inclusive of the information I need it to alert my dispatchers when specific tank volumes are at a critical state so a load can be planned, without having to select numerous variables.
I think the variables that can be specified would be the Types of product.
1. Load the customer tank file.
2. Create a chart with Dimensions Customer, TankID. Maximum Volume, etc.
3. Use a chart expression that filters with a Set Expression to the thresholds you want: Something like:
Sum({ <TankConfiguration={'UNL'},CurrentVolume={">=4000"}>
+ <TankConfiguration={'Premium '},CurrentVolume={">=3000"}>
+ <TankConfiguration={'Diesel '},CurrentVolume={">=3000"}> }
CurrentVolume)
I'm not sure exactly how you mean to use this. As a chart that someone looks at or do you want to send an email alert after reload?
-Rob