# How to create a good looking composite index? **URL:** \ **Category:** Questions & Help\ **Created:** [November 14, 2024, 4:30pm UTC](https://community.homey.app/t/how-to-create-a-good-looking-composite-index/120537 "2024-11-14T16:30:33Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Olivier\_Arthus](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/olivier_arthus/32/88909_2.png) [@Olivier\_Arthus](https://community.homey.app/u/Olivier_Arthus)\ **Post date:** [November 14, 2024, 4:30pm UTC](https://community.homey.app/t/how-to-create-a-good-looking-composite-index/120537/1 "2024-11-14T16:30:33Z")
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 ---
**Author:** ![Anders\_Gregow](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/anders_gregow/32/61721_2.png) [@Anders\_Gregow](https://community.homey.app/u/Anders_Gregow)\ **Post date:** [November 15, 2024, 7:20am UTC](https://community.homey.app/t/how-to-create-a-good-looking-composite-index/120537/2 "2024-11-15T07:20:11Z")
Use Google Sheets app? ---
**Author:** ![Olivier\_Arthus](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/olivier_arthus/32/88909_2.png) [@Olivier\_Arthus](https://community.homey.app/u/Olivier_Arthus)\ **Post date:** [November 15, 2024, 7:24am UTC](https://community.homey.app/t/how-to-create-a-good-looking-composite-index/120537/3 "2024-11-15T07:24:28Z")
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