wrkg - 2012-06-19

On an overview.html page I am able to create a "count" type block that groups by "org_id_friendlyname" but I'm unable to display an "open_flash_chart" pie type chart that groups by the friendlyname. Grouping by "org_id" works for me but will show the ID number of the organizations which limits the usefulness of the graph.

<itopblock BlockClass="DisplayBlock"  type="count" parameters="group_by:consumer_org_id_friendlyname;" asynchronous="false" encoding="text/oql">SELECT CustomerContract</itopblock>

Will work.

<itopblock BlockClass="DisplayBlock"  type="open_flash_chart" parameters="chart_type:pie;group_by:consumer_org_id_friendlyname;" asynchronous="false" encoding="text/oql">SELECT CustomerContract</itopblock>

Gives an "Error in template (please contact your administrator)" message.

<itopblock BlockClass="DisplayBlock"  type="open_flash_chart" parameters="chart_type:pie;group_by:consumer_org_id;" asynchronous="false" encoding="text/oql">SELECT CustomerContract</itopblock>

Will work, but shows ID numbers and not names.

Are there any ways to solve this issue?