search

open-contracting / bi.open-contracting.org

0 stars 0 forks source link

Add chart: Market concentration per item category (R051) #28

Open sabahfromlondon opened 1 year ago

sabahfromlondon commented 1 year ago

Chart details:

Additional details:

vgeryarbc commented 1 year ago

Do we have market share data to calculate HHI ?

jpmckinney commented 1 year ago

@Camilamila For HHI, the requirements document describes:

This is a calculation that uses the Herfindahl–Hirschman Index (HHI).

Formula → HHI = s²1 + s²2 + s²3 + s²4 + ….s²n where S²n = the market share percentage of firm n expressed as a whole number.

HHI can range from close to 0 (near perfect competition) to 10,000 (a monopoly).

Does that mean we calculate HHI, treating only the transactions with SERCOP as the "market"?

Once we're agreed on the methodology, I can decide where to calculate it, to provide to Power BI.

Camilamila commented 1 year ago

The HHI should be calculated for each market. In this case we can define the market using the CPV classifications, we can use level 2, if there are too many categories, we can use the higher level 1. And we flag markets with high HHI (>2500)

jpmckinney commented 6 months ago

Okay, so this is R051 which needs to be implemented first.

vgeryarbc commented 5 months ago

Okay, so this is R051 which needs to be implemented first.

@jpmckinney I didn't find R051 data in ecuador_sercop_bulk_result.

vgeryarbc commented 3 months ago

@jpmckinney do we have to do smth.. or I am just wailing?

jpmckinney commented 3 months ago

I think nothing to do until I implement the indicator.

Camilamila commented 1 month ago

Since the HHI index has not been implemented yet, can we remove this chart, to avoid confusion from the users. @vgeryarbc

vgeryarbc commented 1 month ago

Hi @Camilamila @jpmckinney ! HHI chart removed (temporarily hidden). image