# dashboard_version

created: 2024-10-22 06:58:14
data:
  {"annotations":{"list":[{"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"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] Release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":9,"iteration":1729580188195,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":true,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"[[full_name]] [[metric]] countries stats ([[repogroup_name]])","fill":3,"fillGradient":0,"gridPos":{"h":21,"w":24,"x":0,"y":0},"hiddenSeries":false,"id":2,"legend":{"alignAsTable":true,"avg":true,"current":true,"max":true,"min":true,"rightSide":true,"show":true,"sort":"avg","sortDesc":true,"total":false,"values":true},"lines":false,"linewidth":0,"links":[],"nullPointMode":"null as zero","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[],"spaceLength":10,"stack":true,"steppedLine":true,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"measurement":"notused","orderByTime":"ASC","policy":"default","rawQuery":true,"rawSql":"select\n  time,\n  ${countries:csv}\nfrom\n  s[[cum]]\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = '[[cum]][[repogroup]][[metric]]'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"[[full_name]] [[metric]] countries stats ([[repogroup_name]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"format":"short","label":"Value","logBase":1,"min":"0","show":true},{"format":"short","label":"","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"[[full_name]] [[metric]] countries stats ([[repogroup_name]])","fill":3,"fillGradient":0,"gridPos":{"h":21,"w":24,"x":0,"y":21},"hiddenSeries":false,"id":4,"legend":{"alignAsTable":true,"avg":true,"current":true,"max":true,"min":true,"rightSide":true,"show":true,"sort":"avg","sortDesc":true,"total":false,"values":true},"lines":true,"linewidth":1,"links":[],"nullPointMode":"null as zero","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"measurement":"notused","orderByTime":"ASC","policy":"default","rawQuery":true,"rawSql":"select\n  time,\n  ${countries:csv}\nfrom\n  s[[cum]]\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = '[[cum]][[repogroup]][[metric]]'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"[[full_name]] [[metric]] countries stats ([[repogroup_name]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"format":"short","label":"Value","logBase":1,"min":"0","show":true},{"format":"short","label":"","logBase":1,"min":"0","show":false}],"yaxis":{"align":false}},{"aliasColors":{},"bars":true,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"[[full_name]] [[metric]] countries stats ([[repogroup_name]])","fill":3,"gridPos":{"h":21,"w":24,"x":0,"y":42},"id":3,"legend":{"alignAsTable":true,"avg":true,"current":true,"max":true,"min":true,"rightSide":true,"show":true,"sort":"avg","sortDesc":true,"total":false,"values":true},"lines":false,"linewidth":0,"links":[],"nullPointMode":"null as zero","percentage":true,"pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[],"spaceLength":10,"stack":true,"steppedLine":true,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"measurement":"notused","orderByTime":"ASC","policy":"default","rawQuery":true,"rawSql":"select\n  time,\n  ${countries:csv}\nfrom\n  s[[cum]]\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = '[[cum]][[repogroup]][[metric]]'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"title":"[[full_name]] [[metric]] countries stats ([[repogroup_name]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"type":"graph","xaxis":{"mode":"time","show":true,"values":[]},"yaxes":[{"format":"short","label":"Value","logBase":1,"max":"100","min":"0","show":true},{"format":"short","label":"","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"content":"${docs:raw}","datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":16,"w":24,"x":0,"y":63},"id":1,"links":[],"mode":"html","title":"Dashboard documentation","type":"text"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","kusionstack"],"templating":{"list":[{"current":{"selected":false,"text":"KusionStack","value":"KusionStack"},"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":"Month","value":"Month"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period_name","options":[],"query":"select split_part(cumperiod_name, '/', 2) from tcumperiods where cumperiod_name like '[[cum]]/%';","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"","current":{"selected":true,"text":["All"],"value":["$__all"]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":true,"label":"Countries","multi":true,"name":"countries","options":[],"query":"select '\"' || country_name || '\"' from tcountries order by time asc","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":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},{"current":{"selected":false,"text":"Contributors","value":"contributors"},"hide":0,"includeAll":false,"label":"Metric","multi":false,"name":"metric","options":[{"selected":false,"text":"Contributions","value":"contributions"},{"selected":true,"text":"Contributors","value":"contributors"},{"selected":false,"text":"Users","value":"users"},{"selected":false,"text":"Activity","value":"events"},{"selected":false,"text":"Pushers","value":"committers"},{"selected":false,"text":"Pushes","value":"commits"},{"selected":false,"text":"Committers","value":"rcommitters"},{"selected":false,"text":"Commits","value":"rcommits"},{"selected":false,"text":"PR creators","value":"prcreators"},{"selected":false,"text":"PRs","value":"prs"},{"selected":false,"text":"Issue creators","value":"issuecreators"},{"selected":false,"text":"Issues","value":"issues"},{"selected":false,"text":"Commenters","value":"commenters"},{"selected":false,"text":"Comments","value":"comments"},{"selected":false,"text":"Reviewers","value":"reviewers"},{"selected":false,"text":"Reviews","value":"reviews"},{"selected":false,"text":"Watchers","value":"watchers"},{"selected":false,"text":"Watches","value":"watches"},{"selected":false,"text":"Forkers","value":"forkers"},{"selected":false,"text":"Forks","value":"forks"}],"query":"contributions,contributors,users,events,committers,commits,rcommitters,rcommits,prcreators,prs,issuecreators,issues,commenters,comments,reviewers,reviews,watchers,watches,forkers,forks","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"No","value":"countries"},"hide":0,"includeAll":false,"label":"Cumulative","multi":false,"name":"cum","options":[{"selected":false,"text":"Yes","value":"countriescum"},{"selected":true,"text":"No","value":"countries"}],"query":"countries,countriescum","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack countries stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/countries.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eCumulative metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/countries_cum.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eCommitters metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/committers_countries.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eCommitters cumulative metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/committers_countries_cum.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ecountries\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/countries-stats.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 countries statistics (cumulative and in given periods).\u003c/li\u003e\n\u003cli\u003eContributor is defined as somebody who made a review, comment, commit, created PR or issue.\u003c/li\u003e\n\u003cli\u003eContribution is a review, comment, commit, issue or PR.\u003c/li\u003e\n\u003cli\u003eWe are determining contributor's country by using GitHub localization and searching for a country using \u003ca href=\"http://www.geonames.org\" target=\"_blank\"\u003egeonames\u003c/a\u003e database.\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary statistics for all of them combined.\u003c/li\u003e\n\u003cli\u003eYou can choose to display contributors, contributions, users, actvity, committers, commits etc.\u003c/li\u003e\n\u003cli\u003eYou can select cumulative statistics or statistics in given periods.\u003c/li\u003e\n\u003cli\u003eWhen you select N Years period it displays data for N-years, for example data for 2020-01-01 with 5 Years period means a summary data for 2015-01-01 00:00:00-2020-01-01 00:00:00.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show data in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\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 activity, 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\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack countries stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/countries.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eCumulative metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/countries_cum.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eCommitters metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/committers_countries.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eCommitters cumulative metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/committers_countries_cum.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ecountries\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/countries-stats.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 countries statistics (cumulative and in given periods).\u003c/li\u003e\n\u003cli\u003eContributor is defined as somebody who made a review, comment, commit, created PR or issue.\u003c/li\u003e\n\u003cli\u003eContribution is a review, comment, commit, issue or PR.\u003c/li\u003e\n\u003cli\u003eWe are determining contributor's country by using GitHub localization and searching for a country using \u003ca href=\"http://www.geonames.org\" target=\"_blank\"\u003egeonames\u003c/a\u003e database.\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary statistics for all of them combined.\u003c/li\u003e\n\u003cli\u003eYou can choose to display contributors, contributions, users, actvity, committers, commits etc.\u003c/li\u003e\n\u003cli\u003eYou can select cumulative statistics or statistics in given periods.\u003c/li\u003e\n\u003cli\u003eWhen you select N Years period it displays data for N-years, for example data for 2020-01-01 with 5 Years period means a summary data for 2015-01-01 00:00:00-2020-01-01 00:00:00.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show data in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\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 activity, 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\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'countries_stats_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"m","value":"m"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"period","options":[],"query":"select split_part(cumperiod_name, '/', 3) from tcumperiods where cumperiod_name like '[[cum]]/[[period_name]]/%';","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-2y","to":"now-1M"},"timepicker":{"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":"Countries Statistics in Repository Groups","uid":"50","version":2,"weekStart":""}


created: 2024-10-22 06:59:16
data:
  {"annotations":{"list":[{"$$hashKey":"object:19","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"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":21,"iteration":1729580198956,"links":[],"liveNow":false,"panels":[{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"","fieldConfig":{"defaults":{"color":{"mode":"thresholds"},"custom":{"align":"auto","displayMode":"auto","inspect":false},"decimals":0,"displayName":"","mappings":[],"thresholds":{"mode":"absolute","steps":[{"color":"green","value":null},{"color":"red","value":80}]},"unit":"short"},"overrides":[{"matcher":{"id":"byName","options":"str"},"properties":[{"id":"displayName","value":"Contributor"},{"id":"unit","value":"short"},{"id":"decimals","value":2},{"id":"custom.align"}]},{"matcher":{"id":"byName","options":"dt"},"properties":[{"id":"displayName","value":"First contribution"},{"id":"unit","value":"none"},{"id":"unit","value":"time: MM/DD/YY h:mm:ss a"},{"id":"custom.align"}]},{"matcher":{"id":"byName","options":""},"properties":[{"id":"unit","value":"short"},{"id":"decimals","value":2},{"id":"custom.align"}]}]},"gridPos":{"h":25,"w":24,"x":0,"y":0},"hideTimeOverride":false,"id":1,"links":[],"options":{"footer":{"fields":"","reducer":["sum"],"show":false},"showHeader":true},"pluginVersion":"8.5.27","targets":[{"alias":"","dsType":"influxdb","format":"table","groupBy":[{"params":["$__interval"],"type":"time"},{"params":["null"],"type":"fill"}],"orderByTime":"ASC","policy":"default","query":"","rawQuery":true,"rawSql":"select str, dt from \"snew_contributors_data\" where $__timeFilter(dt) and series = 'ncd[[repogroup]]' and period = 'd'","refId":"A","resultFormat":"table","select":[[{"params":["value"],"type":"field"},{"params":[],"type":"mean"}]],"tags":[]}],"title":"[[full_name]] New contributors table (Repository group [[repogroup_name]])","transformations":[{"id":"seriesToRows","options":{"reducers":[]}}],"type":"table"},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":11,"w":24,"x":0,"y":25},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","kusionstack","table"],"templating":{"list":[{"current":{"selected":false,"text":"KusionStack","value":"KusionStack"},"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},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack new contributors table dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eNew contributors metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/new_contributors_data.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eNew contributors table\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/new-contributors-table.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 statistics about new PR contributors.\u003c/li\u003e\n\u003cli\u003eNew contributor (PR creator) is someone whose PR was merged for the first time.\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can select date range to show new contributors for this period.\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\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack new contributors table dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eNew contributors metric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/new_contributors_data.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003eNew contributors table\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/new-contributors-table.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 statistics about new PR contributors.\u003c/li\u003e\n\u003cli\u003eNew contributor (PR creator) is someone whose PR was merged for the first time.\u003c/li\u003e\n\u003cli\u003eYou can select single repository group or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can select date range to show new contributors for this period.\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\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'new_contributors_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-6M","to":"now"},"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":"New Contributors Table","uid":"52","version":2,"weekStart":""}


created: 2024-10-22 06:59:44
data:
  {"annotations":{"list":[{"$$hashKey":"object:25","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:26","datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":27,"iteration":1729580204475,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":true,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"description":"Shows review counts for given users and repository.","fieldConfig":{"defaults":{"links":[]},"overrides":[]},"fill":1,"fillGradient":0,"gridPos":{"h":22,"w":24,"x":0,"y":0},"hiddenSeries":false,"hideTimeOverride":false,"id":1,"legend":{"alignAsTable":true,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":true,"show":true,"sort":"avg","sortDesc":true,"total":true,"values":true},"lines":false,"linewidth":1,"links":[],"nullPointMode":"null as zero","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":5,"points":false,"renderer":"flot","seriesOverrides":[],"spaceLength":10,"stack":true,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","groupBy":[],"measurement":"sig_federation_d","orderByTime":"ASC","policy":"default","query":"SELECT /^[[reviewers]]$/ FROM \"reviews_per_user_[[repo]]_[[period]]\" WHERE $timeFilter","rawQuery":true,"rawSql":"select\n  time,\n  ${reviewers:csv}\nfrom\n  suser_reviews\nwhere\n  $__timeFilter(time)\n  and period = '[[period]]'\n  and series = 'rev_per_usr[[repo]]'\norder by\n  time","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[]}],"thresholds":[],"timeRegions":[],"title":"Reviews per user/repo ([[repo_name]], [[period]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":["total"]},"yaxes":[{"format":"short","label":"Number of PR review comments","logBase":1,"min":"0","show":true},{"format":"short","label":"","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":12,"w":24,"x":0,"y":22},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"schemaVersion":36,"style":"dark","tags":["dashboard","kusionstack"],"templating":{"list":[{"current":{"selected":false,"text":"7 Days MA","value":"d7"},"hide":0,"includeAll":false,"label":"Period","multi":false,"name":"period","options":[{"selected":false,"text":"Day","value":"d"},{"selected":false,"text":"Week","value":"w"},{"selected":true,"text":"7 Days MA","value":"d7"},{"selected":false,"text":"Month","value":"m"},{"selected":false,"text":"Quarter","value":"q"},{"selected":false,"text":"Year","value":"y"}],"query":"d,w,d7,m,q,y","skipUrlSync":false,"type":"custom"},{"current":{"selected":false,"text":"All","value":"All"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository","multi":false,"name":"repo_name","options":[],"query":"select top_repos_name_with_all from ttop_repos_with_all 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":"repo","options":[],"query":"select top_repos_value_with_all from ttop_repos_with_all where top_repos_name_with_all = '[[repo_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"allValue":"","current":{"selected":true,"text":["\"elliotxx\"","\"liu-hm19\"","\"ruquanzhao\"","\"Yangyang96\"","\"shaofan-hs\"","\"wu8685\"","\"ColdsteelRail\"","\"SparkYuan\"","\"zoumo\"","\"ffforest\"","\"ekjotsinghmakhija\"","\"Eikykun\"","\"Wenfeng-GAO\"","\"regend\"","\"cheny-alf\"","\"SS-Yuki\"","\"jojohappy\"","\"AnnaYue\"","\"adohe\"","\"Liuxingyu1111111\"","\"hoangndst\"","\"z1cheng\"","\"jueli12\""],"value":["\"elliotxx\"","\"liu-hm19\"","\"ruquanzhao\"","\"Yangyang96\"","\"shaofan-hs\"","\"wu8685\"","\"ColdsteelRail\"","\"SparkYuan\"","\"zoumo\"","\"ffforest\"","\"ekjotsinghmakhija\"","\"Eikykun\"","\"Wenfeng-GAO\"","\"regend\"","\"cheny-alf\"","\"SS-Yuki\"","\"jojohappy\"","\"AnnaYue\"","\"adohe\"","\"Liuxingyu1111111\"","\"hoangndst\"","\"z1cheng\"","\"jueli12\""]},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Reviewer","multi":true,"name":"reviewers","options":[],"query":"select '\"' || reviewers_name || '\"' from treviewers","refresh":1,"regex":"","skipUrlSync":false,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"KusionStack","value":"KusionStack"},"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":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack user reviews dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/reviews_per_user.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ereviews_per_user\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/user-reviews.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 number of PR reviews most active reviewers.\u003c/li\u003e\n\u003cli\u003eReview means user added PR review comment.\u003c/li\u003e\n\u003cli\u003eYou can select reviewer from the reviewers drop-down, it shows top active reviewers from last 3 months.\u003c/li\u003e\n\u003cli\u003eTo find top active reviewers we sum number of reviews per user.\u003c/li\u003e\n\u003cli\u003eYou can select single repository or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can filter by period and choose multiple reviewers to stack their data.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show reviews in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack user reviews dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/reviews_per_user.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ereviews_per_user\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/user-reviews.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 number of PR reviews most active reviewers.\u003c/li\u003e\n\u003cli\u003eReview means user added PR review comment.\u003c/li\u003e\n\u003cli\u003eYou can select reviewer from the reviewers drop-down, it shows top active reviewers from last 3 months.\u003c/li\u003e\n\u003cli\u003eTo find top active reviewers we sum number of reviews per user.\u003c/li\u003e\n\u003cli\u003eYou can select single repository or summary for all of them.\u003c/li\u003e\n\u003cli\u003eYou can filter by period and choose multiple reviewers to stack their data.\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show reviews in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'user_reviews_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-2y","to":"now"},"timepicker":{"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":"PR Reviews by Contributor","uid":"46","version":2,"weekStart":""}


created: 2024-10-22 07:00:18
data:
  {"annotations":{"list":[{"$$hashKey":"object:19","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:20","datasource":{"type":"postgres","uid":"P172949F98CB31475"},"enable":true,"hide":false,"iconColor":"rgba(255, 96, 96, 1)","limit":100,"name":"Releases","query":"SELECT title, description from annotations WHERE $timeFilter order by time asc","rawQuery":"select extract(epoch from time) AS time, title as text, description as tags from sannotations where $__timeFilter(time)","showIn":0,"tagsColumn":"title,description","textColumn":"","titleColumn":"[[full_name]] release","type":"alert"}]},"editable":true,"fiscalYearStartMonth":0,"graphTooltip":0,"id":38,"iteration":1729580214702,"links":[],"liveNow":false,"panels":[{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":0,"description":"Community stats ([[repo_name]])","fieldConfig":{"defaults":{"links":[]},"overrides":[]},"fill":0,"fillGradient":0,"gridPos":{"h":14,"w":24,"x":0,"y":0},"hiddenSeries":false,"id":1,"legend":{"alignAsTable":false,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":true,"linewidth":1,"links":[],"nullPointMode":"null","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":1,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"Stargazers","yaxis":1},{"alias":"Forks","yaxis":2},{"alias":"Open Issues and PRs","yaxis":2}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Stargazers\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'watch[[repo]]watch'\n  and period = 'w'\norder by\n  time\n;","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Forks\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'watch[[repo]]forks'\n  and period = 'w'\norder by\n  time\n;","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"Open Issues and PRs\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'watch[[repo]]opiss'\n  and period = 'w'\norder by\n  time\n;","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]}],"thresholds":[],"timeRegions":[],"title":"Community stats ([[repo_name]])","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":["total"]},"yaxes":[{"format":"none","label":"Stargazers","logBase":1,"min":"0","show":true},{"format":"none","label":"Forks, Open issues and PRs","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"aliasColors":{},"bars":false,"dashLength":10,"dashes":false,"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"decimals":0,"description":"Community stats combined","fieldConfig":{"defaults":{"links":[]},"overrides":[]},"fill":0,"fillGradient":0,"gridPos":{"h":14,"w":24,"x":0,"y":14},"hiddenSeries":false,"id":12,"legend":{"alignAsTable":false,"avg":true,"current":true,"hideEmpty":false,"hideZero":false,"max":true,"min":true,"rightSide":false,"show":true,"total":false,"values":true},"lines":true,"linewidth":1,"links":[],"nullPointMode":"null","options":{"alertThreshold":true},"percentage":false,"pluginVersion":"8.5.27","pointradius":1,"points":false,"renderer":"flot","seriesOverrides":[{"alias":"All Stargazers","yaxis":1},{"alias":"All Forks","yaxis":1},{"alias":"All Open Issues and PRs","yaxis":2}],"spaceLength":10,"stack":false,"steppedLine":false,"targets":[{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"All Stargazers\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'allwatchallwatch'\n  and period = 'w'\norder by\n  time\n;","refId":"A","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"All Forks\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'allwatchallforks'\n  and period = 'w'\norder by\n  time\n;","refId":"B","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]},{"alias":"","dsType":"influxdb","format":"time_series","group":[],"groupBy":[],"hide":false,"measurement":"reviewers_d","metricColumn":"none","orderByTime":"ASC","policy":"autogen","query":"","rawQuery":true,"rawSql":"select\n  time,\n  value as \"All Open Issues and PRs\"\nfrom\n  swatchers w\nwhere\n  $__timeFilter(time)\n  and series = 'allwatchallopiss'\n  and period = 'w'\norder by\n  time\n;","refId":"C","resultFormat":"time_series","select":[[{"params":["value"],"type":"field"}]],"tags":[],"timeColumn":"time","where":[{"name":"$__timeFilter","params":[],"type":"macro"}]}],"thresholds":[],"timeRegions":[],"title":"Community stats combined","tooltip":{"shared":true,"sort":2,"value_type":"individual"},"transparent":true,"type":"graph","xaxis":{"mode":"time","show":true,"values":["total"]},"yaxes":[{"format":"none","label":"Stargazers","logBase":1,"min":"0","show":true},{"format":"none","label":"Forks, Open issues and PRs","logBase":1,"min":"0","show":true}],"yaxis":{"align":false}},{"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"gridPos":{"h":10,"w":24,"x":0,"y":28},"id":11,"links":[],"options":{"content":"${docs:raw}","mode":"html"},"pluginVersion":"8.5.27","title":"Dashboard documentation","type":"text"}],"refresh":false,"schemaVersion":36,"style":"dark","tags":["dashboard","kusionstack"],"templating":{"list":[{"current":{"selected":false,"text":"KusionStack","value":"KusionStack"},"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":true,"text":"KusionStack/kusion","value":"KusionStack/kusion"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":0,"includeAll":false,"label":"Repository","multi":false,"name":"repo_name","options":[],"query":"select top_repo_names_name from ttop_repo_names order by 1","refresh":1,"regex":"","skipUrlSync":false,"sort":1,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"kusionstackkusion","value":"kusionstackkusion"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"label":"","multi":false,"name":"repo","options":[],"query":"select top_repo_names_value from ttop_repo_names where top_repo_names_name = '[[repo_name]]'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false},{"current":{"selected":false,"text":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack community stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/watchers_by_alias.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ewatchers\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/community-stats.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 forks, stars, open issues and PRs charts for a given repository\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show maximum value in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e","value":"\u003ch1 id=\"dashboard-header\"\u003eKusionStack community stats dashboard\u003c/h1\u003e\n\u003cp\u003eLinks:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003eMetric \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/watchers_by_alias.sql\" target=\"_blank\"\u003eSQL file\u003c/a\u003e.\u003c/li\u003e\n\u003cli\u003eTSDB \u003ca href=\"https://github.com/cncf/devstats/blob/master/metrics/shared/metrics.yaml\" target=\"_blank\"\u003eseries definition\u003c/a\u003e. Search for \u003ccode\u003ewatchers\u003c/code\u003e\u003c/li\u003e\n\u003cli\u003eGrafana dashboard \u003ca href=\"https://github.com/cncf/devstats/blob/master/grafana/dashboards/kusionstack/community-stats.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 forks, stars, open issues and PRs charts for a given repository\u003c/li\u003e\n\u003cli\u003eSelecting period (for example week) means that dashboard will show maximum value in those periods.\u003c/li\u003e\n\u003cli\u003eSee \u003ca href=\"https://github.com/cncf/devstats/blob/master/docs/periods.md\" target=\"_blank\"\u003ehere\u003c/a\u003e for more informations about periods.\u003c/li\u003e\n\u003c/ul\u003e"},"datasource":{"type":"postgres","uid":"P172949F98CB31475"},"definition":"","hide":2,"includeAll":false,"multi":false,"name":"docs","options":[],"query":"select value_s from gha_vars where name = 'community_stats_docs_html'","refresh":1,"regex":"","skipUrlSync":true,"sort":0,"tagValuesQuery":"","tagsQuery":"","type":"query","useTags":false}]},"time":{"from":"now-2y","to":"now"},"timepicker":{"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":"Stars and Forks by Repository","uid":"3","version":2,"weekStart":""}


# user_auth_token

auth_token: 2c48b0e4d7c6ee41e49c799e43581a2e5273e843c1526bcafd14e401182fe272
prev_auth_token: 72b93b8514d4e4ac87c35dc3722599e14e29242aa6eee9255226e7bbfd09f38f
client_ip: 192.168.142.192
user_agent:
  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.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>"
  				}
  			}]
  		}]
  	}
  }


