The attached file gives the temperature of different cities which are divided into different zones. I want to create a straight table that displays
City
Temperature of City
Avg Temp in the zone the city falls into
The delta between City temperature and avg temperature in the zone
The output should look like the below table. Please let me know if this can be handled in set analysis itself (how) or we need to take care of Avg zone temperature at the script level before fetching it to the front end.
Thanks for the response. I was however looking for a solution that doesn't require using aggregation function at the script level. Is it possible to achieve the same result without touching the script?
