Run statistics on data which originates in a remote excel file

[Eyal Zmora]

I am using a "table from CSV" macro which is wrapped by  a "Chart from table" macro to display graphical data.

Here is one example:

I would like to display some statistics below the graph, like Average, STD etc.

For example, I would like to calculate what percentage of all data, does value "1" account for. 

Is there any way to run such calculations and display them?

Thanks

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit modes.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Eyal Zmora]

Thanks @Katerina Kovriga _Stiltsoft_ 

Very handy!

[Pramodh M · Accepted solution]

Hi @Eyal Zmora 

Here's a great plugin that may meet your requirements

https://marketplace.atlassian.com/apps/27447/table-filter-and-charts-for-confluence?hosting=datacenter&tab=overview

Let me know if you need further help

Thanks,
Pramodh

[Eyal Zmora]

Thanks @Pramodh M , but I am not sure this is part of the basic Confluence package I currently have at work. 

[Katerina Kovriga _Stiltsoft_]

Hi @Eyal Zmora , the Table from CSV and the Chart from Table macros indeed belong to the Table Filter and Charts for Confluence app, so it seems that you are using it successfully.

To have several aggregated tables/charts based on the one source table (manually created or coming from the CSV table), you may use the Table Excerpt/Table Except Include macros: reuse your source table several times, wrap the reused copies into other macros (Pivot Table, another Chart from Table, etc.) and calculate whatever you need.

With the help of the Table Excerpt/Table Except Include macros you'll get a kind of a dashboard based on the one source table.