-
How do I add a WTD average to a nested bar chart?
I'm familiar with the min/max/average grid lines but they don't appear to work with a nested bar chart - or even with the stacked bar chart I changed it to. I'm showing WTD inventory in lbs. across four orgs (series) for the last 7 days (date grain). The business has asked for a total average inventory across all orgs by…
-
why are my transactions dates coming in as shift dates?
I have a pretty simple query pulling from Oracle tables but it's transforming the dates when I run it through the workbench. In SQL Developer, it returns the Actual Completion Date as 'DD-MON-YY HH24:MI:SS': to_char(gbs.actual_cmplt_date,'DD-MON-YY HH24:MI:SS') "Actual Completion Date" I've used this same syntax to…
-
Calculating Xbar in Beast Mode
I am trying to create a control chart and need to start by calculating the Xbar. In this particular dataset, I have multiple inventory transactions that have occurred during a "subgroup" = one day/week. The Xbar calculation = the sum of the transactions during the subgroup period divided by the # transactions, by inventory…
