Display number from a different website

Hi,

I have a dashboard page with metrics. In this dashboard is a pie chart with a percentage. The percentage comes from a sql query that runs every few hours to calculate this percentage.

Now I want just this percentage of this on my xwiki page.

I thought of 2 options: either I import the number itself, use xwiki as a partial mirror of that piechart. ( Possibly with a {{include reference}} ? )

Or: I somehow manage to run the same query in the background of xwiki.

Either way, I don’t know how to do it, so any help is greatly appreciated.

I think the “include” macro only works to include the content of other XWiki pages.

The simplest solution that I can think of is to use an {{html}} macro instead and embed the pie chart as an iframe. Not sure if this works for you.