Change Details

==== Context We eventually want to have a Dashboard in Superset to look at the Scraper data. A first step into that direction would be having a data set and chart configured that can be used inspect the raw data coming from the aggregations. ==== Task This task is about creating a dataset which can be used in charts. * [ ] Create a new [[ https://superset.apache.org/docs/using-superset/creating-your-first-dashboard#registering-a-new-table | dataset ]] based on the aggregation table `wmde.wiki_page_cite_references_monthly` ( Until this table is created you can also use `wmde_fisch.wiki_page_cite_references_monthly`from T413954 ) * [ ] Configure column types appropriately so that the dataset can be used for a linechart. * [ ] Build a test chart which includes a per-wiki filter (defaulting to dewiki perhaps) and shows a time series.

==== Context We eventually want to have a Dashboard in Superset to look at the Scraper data. A first step into that direction would be having a data set and chart configured that can be used inspect the raw data coming from the aggregations. ==== Task This task is about creating a dataset which can be used in charts. * [x] Create a new [[ https://superset.apache.org/docs/using-superset/creating-your-first-dashboard#registering-a-new-table | dataset ]] based on the aggregation table `wmde.wiki_page_cite_references_monthly` ( Until this table is created you can also use `wmde_fisch.wiki_page_cite_references_monthly`from T413954 ) * [x] Configure column types appropriately so that the dataset can be used for a linechart. * [x] Build a test chart which includes a per-wiki filter (defaulting to dewiki perhaps) and shows a time series. ==== Outcome I created a dataset and test chart using my local db as described above. It seems pretty straight forward. The snapshot date can be used as datetime for the chart and the lines can be configured on the chart using `sum()`. https://superset.wikimedia.org/explore/?slice_id=4487

==== Context We eventually want to have a Dashboard in Superset to look at the Scraper data. A first step into that direction would be having a data set and chart configured that can be used inspect the raw data coming from the aggregations. ==== Task This task is about creating a dataset which can be used in charts. * [ * [x] Create a new [[ https://superset.apache.org/docs/using-superset/creating-your-first-dashboard#registering-a-new-table | dataset ]] based on the aggregation table `wmde.wiki_page_cite_references_monthly` ( Until this table is created you can also use `wmde_fisch.wiki_page_cite_references_monthly`from T413954 ) * [ * [x] Configure column types appropriately so that the dataset can be used for a linechart. * [ * [x] Build a test chart which includes a per-wiki filter (defaulting to dewiki perhaps) and shows a time series. ==== Outcome I created a dataset and test chart using my local db as described above. It seems pretty straight forward. The snapshot date can be used as datetime for the chart and the lines can be configured on the chart using `sum()`. https://superset.wikimedia.org/explore/?slice_id=4487