| You can include any additonal Statistical methods using Open Source R, Tibco Enterprise Runtime for R,
SAS, Matlab
|
| Avg(Arg1, ...) |
| ChiDist(Arg1) |
| ChiInv(Arg1) |
| Count(Arg1) |
| CountBig(Arg1) |
| Covariance(Arg1, Arg2) |
| FDist(Arg1) |
| FInv(Arg1) |
| First(Arg1) |
| GeometricMean() |
| IQR(Arg1) |
| L95(Arg1) |
| Last(Arg1) |
| LAV(Arg1) |
| LIF(Arg1) |
| LOF(Arg1) |
| Max(Arg1, ...) |
| MeanDeviation(Arg1, ...) |
| Median(Arg1) |
| MedianAbsoluteDeviation(Arg1, ...) |
| Min(Arg1, ...) |
| NormDist(Arg1) |
| NormInv(Arg1) |
| NthLargest(Arg1, Arg2) |
| NthSmallest(Arg1, Arg2) |
| Outliers(Arg1) |
| P10(Arg1) |
| P90(Arg1) |
| PctOutliers(Arg1) |
| Percent(Arg1, Arg2) |
| Percentile(Arg1, Arg2) |
| Q1(Arg1) |
| Q3(Arg1) |
| Range(Arg1) |
| StdDev(Arg1) |
| StdErr(Arg1) |
| TDist(Arg1) |
| TInv(Arg1) |
| TrimmedMean(Arg1, Arg2) |
| U95(Arg1) |
| UAV(Arg1) |
| UIF(Arg1) |
| UniqueCount(Arg1) |
| UOF(Arg1) |
| ValueForMax(Arg1, Arg2) |
| ValueForMin(Arg1, Arg2) |
| Var(Arg1) |
| WeightedAverage(Arg1, Arg2) |
| There are also |
| Binning functions |
I recently had a colleague asking me to show him the data in a calendar format.. Something like this I basically used a scatterplot for this. You can check out the original DXP here http://bit.ly/spotcalendar Some key settings to make it a calendar. Please note Order date is the date of interest here These expressions are out of the box expressions, no need to handcode them, but select them in the axis value X Axis <BinByDateTime([Order Date],"DayOfWeek",0)> Y Axis Week([Order Date]) Trellis into panels <BinByDateTime([Order Date],"Year.Quarter.Month",2)> Manual layout 4 X 3 Labels UniqueConcatenate(DayOfMonth([Order Date])) Shape Tiled Markers Marker by <UniqueConcatenate([Order Date])> Happy plotting your calendar!!!
Comments
Post a Comment