Here's a cool trick I learn last week that changed my life, hope it can put a smile on some of your faces as well.

Currently, in Pages, when adding a Chart, you can input aggregated or actual values as Y axis. When choosing aggregated values, you can only select SUM of fields.

// How to

Well, if you go play in the Application IDE a bit, it actually supports other mathematic logic. So far, I've only tested MIN, but I expect this to work with MAX and probably AVR as well, up to you to try it out.

The trick is to go in your Application IDE in Settings, find your Page and change your "sum:fieldname" by "min:fieldname". If you try saving like this and leave the Application IDE, ZC will revert your code and input SUM back. But if you also change something else in the code (say the chart background color) and save, by magic the MIN is kept and your chart will reflect as such.

// Use case

Having a chart to display two columns, one as the sum of all your staff workload for a project (sum:workload) vs that project's budgeted hour (min.project.budgetedHours). See picture attached.

You can definitely make this with a pivotable chart, but Page's chart allow for usage of parameter, instant refresh and much more. 

It would be nice if ZC could support this natively, but at least there is the possibility of doing it through Application IDE.

To Zoho: if this is a bug: PLEASE DON'T CORRECT IT!!!! :O 

Cheers.

B.