REPORT PARAMETERS

Report not found

There was a problem finding this report.
Customer Success Cube
November 15, 2017 · Refreshed 21 days ago

Collaborators

Run History
SELECT CASE WHEN 'Year' = 'Year' THEN TO_CHAR(month,'YYYY') ELSE TO_CHAR(month,'MON - YY') END AS interval, agent, ROUND((AVG(retention_rate)*100)::numeric,0) AS retention_rate, ROUND((AVG(expansion_mrr_perc)*100)::numeric,0) AS expansion_mrr_rate, ROUND(AVG(nps)::numeric,0) AS nps FROM demo.customer_success GROUP BY 1,2 ORDER BY 1,2
SELECT CASE WHEN '{{ interval }}' = 'Year' THEN TO_CHAR(month,'YYYY') ELSE TO_CHAR(month,'MON - YY') END AS interval, agent, ROUND((AVG(retention_rate)*100)::numeric,0) AS retention_rate, ROUND((AVG(expansion_mrr_perc)*100)::numeric,0) AS expansion_mrr_rate, ROUND(AVG(nps)::numeric,0) AS nps FROM demo.customer_success GROUP BY 1,2 ORDER BY 1,2 {% form %} interval: type: select default: Year options: [Month,Year] {% endform %}
<link rel="stylesheet" href="https://mode.github.io/alamode/alamode.min.css"> <script src="https://mode.github.io/alamode/alamode.min.js"></script> <style> body { background: #3a3a45 !important; } .chart { background-color: #3a3a45; border: none; } .mode-embed .mode-object { border: none; background: #3a3a45; } .js-table-container { background-color: #3a3a45; } .modebar--hover { visibility: hidden; } </style> <div class="mode-header embed-hidden"> </div> <div class="mode-grid container"> <div class="row" data-row-height="large"> <div class="col-md-12"> <mode-python id="python_e06e3ccfe04c" options="python_options"></mode-python> </div> </div> </div> <script> alamode.resizeChartHeight( { chart: "python_e06e3ccfe04c", height: 1000 } ) </script>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled