11-24-2014 03:12 PM
As part of a Business Rule, there is a requirement of using the Median as part of the condition, one of the approach we are trying to take is to see if its part of any of the profiling node which then can be used in conjunction of the Data Monitoring node in a data job.
Hence the following query
1) Is there any manner wherein I can capture the Median Statistic that is outputted as part of a Profiling activity, if Not
2) Any one who has used the expression node to generate the median.
11-25-2014 11:49 AM
There is not a straightforward way to do this with just one expression. I have attached a screenshot of a job that will calculate the median:
The other variables are ones that were created to assist in the median calculation.
12-01-2014 09:22 AM