AI Agent - Using SVG Pie Chart representation for extracted data from an OTBI report

Question

Hello experts, I need to generate output from an OTBI analysis in the form of a Pie chart, in Oracle Fusion AI Agent Studio. I'm trying to leverage SVG Charts using LLM Prompts. But its not working as expected. Ex: (Agent Prompt in LLM) ****************************************************************************************************************************** You are to provide an SVG (no javascript) pie chart, display all Hold Totals as slices of the pie. chart format: * Wrap the SVG chart into a div and maximize the real estate available to you * Title: Hold Totals as h4 * Include a legend with color code below the chart, with each item vertically stacked. Add a margin or padding between with the chart to avoid overlapping * Ensure the chart is clear and visible (for example size 525 x 525 viewBox="0 0 400 420" and width: -webkit-fill-available;) * Add the total number of holds at the center of the pie * Ensure percentages are centered if any are displayed ******************************************************************************************************** But the Agent is not able to convert the SVG components into chart, where as Legend comes up fine as you see below. The LLM generated tags are as below: (Tried giving an Example as below in the custom LLM Prompt as well - instead of instructions in plain text/along with it)

Hold Totals

ABC Supplies — 22

Windsor Inc Ltd — 2

Dell Inc. — 1

Tried using a 3 card approach and it worked. But I wanted to work this out with SVG. Any help is much appreciated!! Thanks

RVohra · Answer

@Rima Nair-Oracle , Welcome to the Oracle AI Service Forum. I have gone thru your post and extensive explanation and understood that there is a need to create pie chart.

Have you considered, building the pie chart directly in OTBI and somehow export it as image and ask agent to return that image.

Hope it helps!

Gianni Ceresa · Answer

Hi,

Oracle AI Fusion Agent Studio is more a Fusion product than an Oracle Analytics or AI product.

Fusion and all the related products are covered in a parallel, but independent, forum:

https://community.oracle.com/customerconnect

Rima Nair-Oracle · Answer

To add, I tried a simple SVG test code (just a circle) to see if its being picked up by the agent, but no luck. agent shows nothing (just the header)..The same code comes up in the LLM output, just that agent is not converting them