nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Pramodh M

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

Katerina Kovriga {Stiltsoft}

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.

All comments

Pramodh M

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.

Katerina Kovriga {Stiltsoft}

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

table