REPORT PARAMETERS

Report not found

There was a problem finding this report.
Hiding names
June 18, 2018 · Refreshed 9 months ago

Collaborators

Run History
SELECT CASE WHEN s.name = 'Eugena Esser' THEN s.name ELSE LEFT(MD5(s.name),8) END AS name, CASE WHEN s.name = 'Eugena Esser' THEN 'selected' ELSE 'orders' END AS grouping, SUM(standard_qty) AS orders FROM demo.accounts a JOIN demo.sales_reps s ON s.id = a.sales_rep_id JOIN demo.orders o ON o.account_id = a.id GROUP BY 1,2
SELECT CASE WHEN s.name = '{{name}}' THEN s.name ELSE LEFT(MD5(s.name),8) END AS name, CASE WHEN s.name = '{{name}}' THEN 'selected' ELSE 'orders' END AS grouping, SUM(standard_qty) AS orders FROM demo.accounts a JOIN demo.sales_reps s ON s.id = a.sales_rep_id JOIN demo.orders o ON o.account_id = a.id GROUP BY 1,2 {% form %} name: type: text default: 'Eugena Esser' {% endform %}
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row" data-row-height="large"> <div class="col-md-12"> <mode-chart id="chart_9c2eb03c814c" dataset="dataset" options="chart_options"></mode-chart> </div> </div> </div> <script> var f = d3.format(","); var data = datasets[0].content, median = d3.median(data, function(d) { return d.orders; }); var selectedRow = _.filter(data, {'grouping':'selected'}), selectedName = selectedRow[0].name; setTimeout(function() { var chart = Highcharts.charts[0]; chart.update({ yAxis: { plotLines: [{ color: '#666666', value: median, width: 2, zIndex: 10, label: { text: 'Median sales: ' + f(median), align: 'left', x: 10, y: -10, style: { color: '#666666' } } }] } }); var axisData = chart.xAxis[0].categories; axisData.forEach(function(a,i) { if (a != selectedName) { axisData[i] = '' } }) chart.xAxis[0].setCategories(axisData, true, true); }, 100); </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