How to create a good looking composite index?

Questions & Help
1

Hello

I would like to display an air quality index.
I am using the Weather by Open Meteo app which provides over 15 air quality measures.
I want to use these measures to calculate an weighted average, which, when added up together will provide me a total score out of 100 (let’s say).
Then I would like to display

  • total score out of 100
  • a text saying from bad to excellent based on predefined buckets (for instance from 0-10% bad, … from 90-100% excellent)
    Any idea how this could be achieved?

Thanks

1 Like
2

Use Google Sheets app?

3

Thanks Anders, interesting option, that I did not know existed
I will give it a try a let you know if it works for my need

Thanks

1 Like