Method: FactMetrics::PercentageConfig#sql

Defined in:
lib/fact_metrics/percentage_config.rb

#sql ⇒ Object 



23
24
25
26
27
28
29
30
31
32
33
34
 
# File 'lib/fact_metrics/percentage_config.rb', line 23

def sql
  "    ROUND(\n      (\n        CAST(COUNT(*) FILTER (WHERE \#{condition_sql}) AS FLOAT)\n        /\n        NULLIF(\#{denominator_sql}, 0)\n      ) * 100,\n      2\n    ) AS \#{sql_result_name}\n  SQL\nend\n"