OliverKeyes has uploaded a new change for review.
https://gerrit.wikimedia.org/r/258198
Change subject: Add spider information to dashboards
......................................................................
Add spider information to dashboards
What it says on the tin.
Bug: T120284
Change-Id: Ib8d12133adb3a25751932992eb2e863a0facdd46
---
M server.R
M tab_documentation/wdqs_basic.md
M ui.R
M utils.R
4 files changed, 26 insertions(+), 4 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/discovery/twilightsparql
refs/changes/98/258198/1
diff --git a/server.R b/server.R
index 215e300..1c3fe9a 100644
--- a/server.R
+++ b/server.R
@@ -18,6 +18,7 @@
wdqs_usage %>%
polloi::smoother(smooth_level =
polloi::smooth_switch(input$smoothing_global, input$smoothing_usage)) %>%
polloi::subset_by_date_range(time_frame_range(input$usage_timeframe,
input$usage_timeframe_daterange)) %>%
+ spider_subset(val = input$include_automata) %>%
polloi::make_dygraph(xlab = "Date", ylab = "Events", title = "Daily WDQS
Homepage usage", group = "usage") %>%
dyLegend(labelsDiv = "usage_legend") %>%
dyAnnotation(as.Date("2015-09-07"), text = "A", tooltip = "WDQS
Announced Publically")
@@ -27,6 +28,7 @@
sparql_usage %>%
polloi::smoother(smooth_level =
polloi::smooth_switch(input$smoothing_global, input$smoothing_usage)) %>%
polloi::subset_by_date_range(time_frame_range(input$usage_timeframe,
input$usage_timeframe_daterange)) %>%
+ spider_subset(val = input$include_automata) %>%
polloi::make_dygraph(xlab = "Date", ylab = "Events", title = "Daily
SPARQL usage", group = "usage") %>%
dyLegend(labelsDiv = "usage_legend") %>%
dyAnnotation(as.Date("2015-09-07"), text = "A", tooltip = "WDQS
Announced Publically") %>%
diff --git a/tab_documentation/wdqs_basic.md b/tab_documentation/wdqs_basic.md
index 609e841..7082483 100644
--- a/tab_documentation/wdqs_basic.md
+++ b/tab_documentation/wdqs_basic.md
@@ -1,6 +1,9 @@
Wikidata Query Service (WDQS) usage
=======
+This displays data on the use of the Wikidata Query Service (WDQS). Amongst
other things, you can filter out automated software (or
+what looks like automated software) although this option does not operate on
data prior to 3 December 2015.
+
Outages and inaccuracies
------
diff --git a/ui.R b/ui.R
index 74694cb..14dd8f4 100644
--- a/ui.R
+++ b/ui.R
@@ -1,3 +1,4 @@
+source("utils.R")
library(shiny)
library(shinydashboard)
library(dygraphs)
@@ -35,6 +36,7 @@
column(polloi::timeframe_select("usage_timeframe"), width = 3),
column(polloi::timeframe_daterange("usage_timeframe"), width =
3),
column(div(id = "usage_legend"), width = 3)),
+ spider_checkbox("include_automata"),
dygraphOutput("wdqs_usage_plot", height = "200px"),
dygraphOutput("sparql_usage_plot", height = "200px"),
includeMarkdown("./tab_documentation/wdqs_basic.md"))
diff --git a/utils.R b/utils.R
index 4ef09bb..86356e3 100644
--- a/utils.R
+++ b/utils.R
@@ -4,17 +4,32 @@
library(dplyr)
read_wdqs <- function() {
- data <- polloi::read_dataset("wdqs/wdqs_aggregates.tsv") %>%
- dplyr::rename(date = timestamp) %>%
+ data <- polloi::read_dataset("wdqs/wdqs_aggregates_new.tsv") %>%
dplyr::arrange(date)
wdqs_usage <<- data %>%
dplyr::filter(path == "/" & http_success) %>%
- dplyr::select(c(date, events)) %>% as.data.frame
+ dplyr::select(c(date, is_automata, events)) %>% as.data.frame
sparql_usage <<- data %>%
dplyr::filter(path == "/bigdata/namespace/wdq/sparql" & http_success) %>%
- dplyr::select(c(date, events)) %>% as.data.frame
+ dplyr::select(c(date, is_automata, events)) %>% as.data.frame
return(invisible())
}
+
+spider_checkbox <- function(input_id){
+ checkboxInput(input_id, "Include automata", value = TRUE, width = NULL)
+}
+
+spider_subset <- function(data, val){
+
+ if(!val){
+ data <- data[!data$is_automata,]
+ }
+
+ return({
+ data %>% group_by(date) %>%
+ summarise(events = sum(events))
+ })
+}
--
To view, visit https://gerrit.wikimedia.org/r/258198
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib8d12133adb3a25751932992eb2e863a0facdd46
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/discovery/twilightsparql
Gerrit-Branch: master
Gerrit-Owner: OliverKeyes <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
