# dashboard_version

created: 2024-04-25 05:02:08
data:
  {"annotations":{"list":[{"$$hashKey":"object:37","builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations \u0026 Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"},{"$$hashKey":"object:142","datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tags":[],"type":"tags"}]},"description":"","editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":8,"iteration":1714021322505,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":true,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Contributions mean the current metric count. Contributors mean the current metric's authors count. When the aggregation period \"7 Days MA\" is used - the weekly number of authors is displayed and the average daily number of contributions (which is the total number of contributions in a moving average week divided by 7).","fieldConfig":{"defaults":{"links":[]},"overrides":[]},"fill":0,"fillGradient":0,"gridPos":{"h":21,"w":24,"x":0,"y":0},"hiddenSeries":false,"id":5,"interval":"","legend":{"alignAsTable":true,"avg":true,"current":true,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":false,"linewidth":1,"nullPointMode":"null as zero","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":2,"points":false,"renderer":"flot","seriesOverrides":[{"$$hashKey":"object:2209","alias":"Contributors","bars":false,"color":"#C4162A","lines":true,"linewidth":2,"yaxis":2},{"$$hashKey":"object:191","alias":"Contributions","color":"#1F60C4"}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"format":"time_series","group":[],"metricColumn":"none","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Contributions\"\nfrom\n  scs\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'cs[[metric]][[repogroup]][[country]][[company]]evs'\norder by\n  time","refId":"A","select":[[{"params":["lang_perc"],"type":"column"}]],"table":"gha_repos_langs","timeColumn":"dt","timeColumnType":"timestamp","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"format":"time_series","group":[],"metricColumn":"none","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Contributors\"\nfrom\n  scs\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'cs[[metric]][[repogroup]][[country]][[company]]acts'\norder by\n  time","refId":"B","select":[[{"params":["lang_perc"],"type":"column"}]],"table":"gha_repos_langs","timeColumn":"dt","timeColumnType":"timestamp","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]}],"thresholds":[],"timeRegions":[],"title":"[[metric]] chart: aggregation: [[period]], repository group: [[repogroup_name]], country: [[country_name]], company: [[company_name]]","tooltip":{"shared":true,"sort":0,"value_type":"individual"},"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"$$hashKey":"object:2039","decimals":2,"format":"none","label":"Contributions","logBase":1,"min":"0","show":true},{"$$hashKey":"object:2040","decimals":0,"format":"none","label":"Contributors","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":18,"w":24,"x":0,"y":21},"id":3,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","cii","companies","repogroups"],"templating":{"list":[{"current":{"selected":false,"text":"Week","value":"w"},"hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period","options":[{"$$hashKey":"object:1598","selected":false,"text":"7 Days MA","value":"d7"},{"$$hashKey":"object:1600","selected":true,"text":"Week","value":"w"},{"$$hashKey":"object:1601","selected":false,"text":"Month","value":"m"}],"query":"d7,w,m","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"Contributions","value":"contributions"},"hide":0,"includeAll":false,"label":"Metric","multi":false,"name":"metric","options":[{"$$hashKey":"object:1425","selected":false,"text":"Comments","value":"comments"},{"$$hashKey":"object:1426","selected":false,"text":"Commit comments","value":"commitcomments"},{"$$hashKey":"object:1427","selected":false,"text":"Commits","value":"commits"},{"$$hashKey":"object:1428","selected":false,"text":"GitHub events","value":"events"},{"$$hashKey":"object:1429","selected":false,"text":"GitHub pushes","value":"pushes"},{"$$hashKey":"object:1430","selected":true,"text":"Contributions","value":"contributions"},{"$$hashKey":"object:1431","selected":false,"text":"Issue comments","value":"issuecomments"},{"$$hashKey":"object:1432","selected":false,"text":"Issues","value":"issues"},{"$$hashKey":"object:1433","selected":false,"text":"PRs","value":"prs"},{"$$hashKey":"object:1434","selected":false,"text":"Merged PRs","value":"mergedprs"},{"$$hashKey":"object:1435","selected":false,"text":"Review comments","value":"reviewcomments"}],"query":"comments,commitcomments,commits,events,pushes,contributions,issuecomments,issues,prs,mergedprs,reviewcomments","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"CII","value":"CII"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"full_name","options":[],"query":"select value_s from gha_vars where name = 'full_name'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository group","multi":false,"name":"repogroup_name","options":[],"query":"select all_repo_group_name from tall_repo_groups order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repogroup","options":[],"query":"select all_repo_group_value from tall_repo_groups where all_repo_group_name = '[[repogroup_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"all","current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"select sub.name from (select 'All' as name, 0 as ord union select country_name as name, 1 as ord from tcountries) sub order by sub.ord, sub.name","hide":0,"includeAll":false,"label":"Country","multi":false,"name":"country_name","options":[],"query":"select sub.name from (select 'All' as name, 0 as ord union select country_name as name, 1 as ord from tcountries) sub order by sub.ord, sub.name","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"select sub.value from (select country_value as value, 0 as ord from tcountries where country_name = '[[country_name]]' union select 'all', 1 as ord) sub order by sub.ord limit 1","hide":2,"includeAll":false,"label":"","multi":false,"name":"country","options":[],"query":"select sub.value from (select country_value as value, 0 as ord from tcountries where country_name = '[[country_name]]' union select 'all', 1 as ord) sub order by sub.ord limit 1","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"","current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"select sub.name from (select 'All' as name, '1900-01-01' as time union select companies_name, time from tcompanies) sub order by sub.time","hide":0,"includeAll":false,"label":"Company","multi":false,"name":"company_name","options":[],"query":"select sub.name from (select 'All' as name, '1900-01-01' as time union select companies_name, time from tcompanies) sub order by sub.time","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"","current":{"selected":false,"text":"all","value":"all"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"select sub.value from (select companies_value as value, 0 as ord from tcompanies where companies_name = '[[company_name]]' union select 'all', 1 as ord) sub order by sub.ord limit 1","hide":2,"includeAll":false,"label":"","multi":false,"name":"company","options":[],"query":"select sub.value from (select companies_value as value, 0 as ord from tcompanies where companies_name = '[[company_name]]' union select 'all', 1 as ord) sub order by sub.ord limit 1","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1\u003eCII Contributions chart dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eCommitters metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/committers.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eContributors metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/contributors.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/cii/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eContributions chart\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/cii/contributions-chart.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows various developer metrics groupped by repository groups, counteries and companies.\u003c/li\u003e\n\u003cli\u003eYou can select last day, month, week or 7 days moving average.\u003c/li\u003e\n\u003cli\u003eIf you select moving average, you will see the number of contributors in a moving 7 day average window and the number of contributions in that window divided by 7.\u003c/li\u003e\n\u003cli\u003eYou can select repository group or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can select country from a drop-down or summary for all countries.\u003c/li\u003e\n\u003cli\u003eYou can select company from a drop-down or summary for all companies.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are skipping bots when calculating statistics, see \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/excluding_bots.md\" target=\"_blank\"\u003eexcluding bots\u003c/a\u003e for details.\u003c/li\u003e\n\u003cli\u003eWe are determining user's company affiliation from \u003ca href=\"https://github.com/cncf/devstats/blob/master/github_users.json\" target=\"_blank\"\u003ethis file\u003c/a\u003e, which is imported from \u003ccode\u003ecncf/gitdm\u003c/code\u003e.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1\u003eCII Contributions chart dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eCommitters metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/committers.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eContributors metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/contributors.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/cii/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eContributions chart\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/cii/contributions-chart.json\" target=\"_blank\"\u003eJSON\u003c/a\u003e.\u003c/li\u003e\n\u003c/ul\u003e\n\u003ch1 id=\"description\"\u003eDescription\u003c/h1\u003e\n\u003cul\u003e\n\u003cli\u003eThis dashboard shows various developer metrics groupped by repository groups, counteries and companies.\u003c/li\u003e\n\u003cli\u003eYou can select last day, month, week or 7 days moving average.\u003c/li\u003e\n\u003cli\u003eIf you select moving average, you will see the number of contributors in a moving 7 day average window and the number of contributions in that window divided by 7.\u003c/li\u003e\n\u003cli\u003eYou can select repository group or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can select country from a drop-down or summary for all countries.\u003c/li\u003e\n\u003cli\u003eYou can select company from a drop-down or summary for all companies.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/repository_groups.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about repository groups.\u003c/li\u003e\n\u003cli\u003eWe are skipping bots when calculating statistics, see \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/excluding_bots.md\" target=\"_blank\"\u003eexcluding bots\u003c/a\u003e for details.\u003c/li\u003e\n\u003cli\u003eWe are determining user's company affiliation from \u003ca href=\"https://github.com/cncf/devstats/blob/master/github_users.json\" target=\"_blank\"\u003ethis file\u003c/a\u003e, which is imported from \u003ccode\u003ecncf/gitdm\u003c/code\u003e.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"select value_s from gha_vars where name = 'contributions_chart_docs_html'","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'contributions_chart_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-2y","to":"now-2d"},"timepicker":{"hidden":false,"refresh_intervals":["5s","10s","30s","1m","5m","15m","30m","1h","2h","1d"],"time_options":["5m","15m","1h","6h","12h","24h","2d","7d","30d"]},"timezone":"","title":"Contributions chart","uid":"74","version":2,"weekStart":""}


# user_auth_token

auth_token: 870995eb1a9003abc67ebe56eeb3adab7a34cf990e53f78a1b988283c1a99bf7
prev_auth_token: 30a45ca97e8a2457faa658fbb1d1100a1ea68167e66be2425a55108dc4e2ceb3
client_ip: 86.109.1.135
user_agent:
  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36


# alert_configuration

configuration_version: v1
configuration_hash: 8c409350c88d78d2ee938448449e628d
alertmanager_configuration:
  {
  	"alertmanager_config": {
  		"route": {
  			"receiver": "grafana-default-email"
  		},
  		"receivers": [{
  			"name": "grafana-default-email",
  			"grafana_managed_receiver_configs": [{
  				"uid": "",
  				"name": "email receiver",
  				"type": "email",
  				"isDefault": true,
  				"settings": {
  					"addresses": "<example@email.com>"
  				}
  			}]
  		}]
  	}
  }


