Extract rank/count/percentage from State of X surveys

[foolip]

I was looking at https://web-platform-dx.github.io/web-features-explorer/features/function/ and wanted to know if @function was a big theme in https://2025.stateofcss.com/en-US/usage/#favorite_new_features or not.

Clicking through the answer can be found, it's not in the top 10 features and it's only 0.3% of responses, so it's not a strong signal.

@captainbrosset isn't sure if the Devographics API exposes the information or not, currently https://github.com/web-platform-dx/web-features-mappings/blob/main/scripts/update-state-of-surveys-mapping.js doesn't use the GraphQL API but instead clones the Devographics monorepo and gets the mapping from there.

@SachaG does the API have the information, and how could it be queried for a specific feature like @function (web-features ID "function")?

[captainbrosset]

It think the API does expose the information we need, but I could use some help in creating the right query.
The thing to consider is that we don't want to query feature by feature. This information is used at build time, when building the explorer website (which happens daily). Ideally, we'd extract all the information at once from the API, for all features, in one API call.

[captainbrosset]

Cloning the Devographics repo might still be a viable option, and we might not need to use the API after all. I found that the data we'd like to expose is in the JSON files that we already parse during the explorer's website build process.

For example, the feature which @foolip was looking for is here https://github.com/Devographics/surveys/blob/b4d5b0e4fdfe0159781f753e01539823217d1f7f/state_of_css/css2025/results/data/usage/favorite_new_features.json#L4888

For now, our script doesn't extract numbers for features, but those numbers are in the JSON file above, so we could improve the script.

Script is here by the way: https://github.com/web-platform-dx/web-features-mappings/blob/main/scripts/update-state-of-surveys-mapping.js

[SachaG]

So this lets you query by feature id: Devographics/Monorepo#514

But if you want to know about ranks or ratios, you'd have to query by section in a specific survey edition since those are values that only exist relative to other items in a section.

For example:

{
  surveys {
    state_of_css {
      css2025 {
        layout {
          _items {
            id
            responses {
              currentEdition {
                editionId
                buckets {
                  id
                  count
                  percentageQuestion
                }
                ratios {
                  awareness
                  interest
                  usage
                  retention
                  positivity
                  positivityRelative
                  appreciation
                }
              }
            }
          }
        }
      }
    }
  }
}
}

I don't know if that helps… I'm happy to jump on a call to help write the right query, or figure out what to add in the API.

That being said if you can use the cached JSON data in the repo that's fine too, it will probably be faster than making big GraphQL queries. The only problem is that those files are not indexed by webFeatureId, but you can always get all internal Devographics ids from the GraphQL API first in a single query:

{
  entities {
    id
    webFeaturesId
  }
}