Research: % of planned trips being cancelled

[hunterowens]

Question

Everybody is saying that the % of trips being cancelled is going up because of the the bus rider short? is this true? by how much?

also for @holly-g prioritization scheme this is a backlog one! Just wanted to write it down before I forgot.

Metrics

• Daily, by agency, percentage of trips / cancelled not run

Data sources

GTFS-RT

Dependencies

• [ ] #840

(Data Servicess Team to Copy and Fill Out Below)

The QuVR MD template below will be filled out by a member of the data services team. This allows us to describe the request, in a way that is easy to hand-off for analysis. After the research phase, we will sync with the asker to figure out if the metric and dashboard pieces are needed.

Before starting research:

• Question: Question written as a single sentence.
• View: E.g. views.gtfs_schedule_fact_daily_feed_files.
• Research:
  • How should the results be presented?
  • When are they needed by?

After reviewing research with the asker:

• Metric: what specific calculations are needed?
• Dashboard: where should we put the result?

[evansiroky]

We might have the data in BigQuery to answer this after merging in https://github.com/cal-itp/data-infra/pull/840