Example #1
0
        /// <inheritdoc cref="ScanShareableAnalyzer{S,M}.AggregationFunctions"/>
        public override IEnumerable <Column> AggregationFunctions()
        {
            Column expression =
                When(RegexpExtract(Column(Column.GetOrElse(string.Empty)), Regex.ToString(), 0) != Lit(""), 1)
                .Otherwise(0);

            Column summation = Sum(AnalyzersExt.ConditionalSelection(expression, Where).Cast("integer"));

            return(new[] { summation, AnalyzersExt.ConditionalCount(Where) });
        }
Example #2
0
        /// <inheritdoc cref="ScanShareableAnalyzer{S,M}.AggregationFunctions"/>
        public override IEnumerable <Column> AggregationFunctions()
        {
            Column summarization = Sum(AnalyzersExt.ConditionalSelection(Column, Where)
                                       .IsNotNull()
                                       .Cast("int"));

            Column conditional = AnalyzersExt.ConditionalCount(Where);

            return(new[] { summarization, conditional });
        }
Example #3
0
        /// <inheritdoc cref="ScanShareableAnalyzer{S,M}.AggregationFunctions"/>
        public override IEnumerable <Column> AggregationFunctions()
        {
            Column summation = Sum(AnalyzersExt.ConditionalSelection(Predicate, Where).Cast("int"));

            return(new[] { summation, AnalyzersExt.ConditionalCount(Where) });
        }
Example #4
0
 /// <inheritdoc cref="StandardScanShareableAnalyzer{S}.AggregationFunctions"/>
 public override IEnumerable <Column> AggregationFunctions() =>
 new[] { AnalyzersExt.ConditionalCount(Where) }.AsEnumerable();