REPORT PARAMETERS

Report not found

There was a problem finding this report.

Report

Cities (Dynamic parameter)

Trips

EXAMPLE (JS) - Render filter values in chart title (select)
December 15, 2017 · Refreshed 2 months ago

Collaborators

Run History
SELECT DATE_TRUNC('month',t.start_date) AS month, s.name AS start_station, COUNT(*) as trips FROM modeanalytics.sf_bike_share_trip t JOIN modeanalytics.sf_bike_share_station s ON t.start_station_id = s.id AND s.city = 'San Jose' WHERE t.start_date BETWEEN '2015-01-01' AND '2015-08-31' GROUP BY 1,2 UNION ALL SELECT DATE_TRUNC('month',t.start_date) AS month, 'total' AS station, COUNT(*) as trips FROM modeanalytics.sf_bike_share_trip t JOIN modeanalytics.sf_bike_share_station s ON t.start_station_id = s.id AND s.city = 'San Jose' WHERE t.start_date BETWEEN '2015-01-01' AND '2015-08-31' GROUP BY 1,2 ORDER BY 1
SELECT DATE_TRUNC('month',t.start_date) AS month, s.name AS start_station, COUNT(*) as trips FROM modeanalytics.sf_bike_share_trip t JOIN modeanalytics.sf_bike_share_station s ON t.start_station_id = s.id AND s.city = '{{ city }}' WHERE t.start_date BETWEEN '2015-01-01' AND '2015-08-31' GROUP BY 1,2 UNION ALL SELECT DATE_TRUNC('month',t.start_date) AS month, 'total' AS station, COUNT(*) as trips FROM modeanalytics.sf_bike_share_trip t JOIN modeanalytics.sf_bike_share_station s ON t.start_station_id = s.id AND s.city = '{{ city }}' WHERE t.start_date BETWEEN '2015-01-01' AND '2015-08-31' GROUP BY 1,2 ORDER BY 1
SELECT DISTINCT city FROM modeanalytics.sf_bike_share_station
SELECT DISTINCT city FROM modeanalytics.sf_bike_share_station {% form %} city: type: select default: Palo Alto options: values: city labels: city {% endform %}
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-12"> <p id="example-paragraph"></p> </div> </div> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_7dbaf731a132" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_c1147823ce95" dataset="dataset" options="table_options"></mode-table> </div> </div> </div> <script> getDataFromQuery = function(queryName) { return datasets.filter(function(d) { return d.queryName == queryName; })[0].content; } $(".checkbox-icon.option-field:contains(\"(All)\")").hide(); var station_name = getDataFromQuery("Trips")[0].start_station; var chartTitle = $("#chart_7dbaf731a132").find(".in-place-edit-text"); var chartTitleText = chartTitle[0].innerText; chartTitle[0].innerText = ''; chartTitle[0].innerHTML = 'SF Bike Share Trips - ' + station_name; //jQuery("a:contains(\'Reset\')").text(""); </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