search

cncf / devstats

📈CNCF-created tool for analyzing and graphing developer contributions
https://devstats.cncf.io
Apache License 2.0
68 stars 25 forks source link

[feature request] Add filter for country in the company-table #68

Open JanMkl opened 4 months ago

JanMkl commented 4 months ago

Could you add a country filter for the company table?

It would be nice to see statistics of companies in different countries or regions if multiple countries could be selected from the filter.

https://all.devstats.cncf.io/d/5/companies-table

lukaszgryglicki commented 4 months ago

I can check on my next CNCF working day, but I think we already have another dashboard that allows filtering by country. Changing this one wold be quite a massive rewrite and would need an approval from @caniszczyk - but let me check that first.

lukaszgryglicki commented 3 months ago

This is something that is most similar to your request: https://all.devstats.cncf.io/d/66/developer-activity-counts-by-companies?orgId=1.

If this is not working for you, can you please LMK what exactly is needed for you? I can then generate a custom report for you (on request) instead of doing very massive chnage in already existing dashboard?

If we really want to update the existing dashboard, then I would need (as I said) approval from @caniszczyk and that would require quite a big changes in the dashboard definition and a LOT of data regenerating, also the question would be if we want this only in "All CNCF" instance, or maybe all instances, or maybe instead of changing the existing dashboard, we want a new one, or just a filter in the existing dashboard that adds a company drop-down but with default option "All companies" which shows the data that we currently show?

JanMkl commented 3 months ago

True developer activity counts have quite close the filters but what I miss from that is the ability generate aggregated counts for organisations/companies which I'm ultimately after. I know that if I pull down the data using the above developer activity count and then for example import the data to excel I can do the aggregated counts for each company/organisation within excel by sorting and summing the values.

It would be much cleaner solution if there would be the country filter in the company table (or then a completely new dashboard) where you could get aggregated results by having a dashboard that has filters for Range, Metric, and Country/Countries (if multiple choices would be supported). This would be neat to be able to show for example in the Cloud-Native-Nordics events some aggregated statistics of the comapnies/organisations participating etc.

lukaszgryglicki commented 3 months ago

Sure, then we need to have @caniszczyk 's approval and I can add "country" drop down with "All" option that will return the same data then.

For now all I can do is to suggest to download CSV export of the another dashboard (the developer one) and sum all developers in Excel or OpenOffice, or request a custom report just for you in a feature request.

JanMkl commented 3 months ago

Thanks. @caniszczyk can you comment on whether you would be ok to add the "country" drop down?

If this is not acceptable add in the existing then I propose that we convert this issue in to custom report request but let's wait for @caniszczyk to comment first.