Create List from Data Type Fields

[jasonh]

I have a list of companies, each company has a list of locations, and each location has 5 fields (1 star, 2 star, etc). The fields hold the count of each star rating for the last 6 months.

I am building a dashboard that will show the star distribution by company using 5 bar charts. Everything works great but I need to set the max value of the bar chart and would like it to be the value of the highest star rating.

My question is how can you get the highest value when they are not in a list? In the lookup, I can get the 1, 2,3,4,or 5 value. I want to be able to select the value that is the highest. Can I make my own list? Any other ideas?

[code-escapee]

How are company and location linked?

Either way you’d extract each location in the Company list and sort by star desc and use the start number of the first one. Just be careful where and how you filter, extract and sort so that you aren’t pulverizing page speed.