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

[JanMkl]

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]

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]

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]

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]

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]

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.