/// <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) }); }
/// <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 }); }
/// <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) }); }
/// <inheritdoc cref="StandardScanShareableAnalyzer{S}.AggregationFunctions"/> public override IEnumerable <Column> AggregationFunctions() => new[] { AnalyzersExt.ConditionalCount(Where) }.AsEnumerable();