Question & Answer > View Question

Get value from spreadsheet column to calculate Median

Confluence User - 25 Feb, 2022

Hi experts,

I am trying to calculate median for a column in a spreadsheet. Is there any way doing this using calculation field? If no, anyone know how to get the value in spreadsheet column so I can work on Java script for median calculation.

Spreadsheet id = spreedSheetASTM

Column id = dumbellThickness

spreadsheet;median

3

Confluence User •

28 Feb, 2022 •

confluenceUser •

•

confluenceUser •

Hi I've found the method by using Javascript API

Confluence User •

29 Jun, 2022 •

confluenceUser •

•

confluenceUser •

I also got same question... have u got solution for this?

Confluence User •

22 Nov, 2022 •

confluenceUser •

•

confluenceUser •

var values = FormUtil.getGridCellValues("spreedSheetASTM.dumbellThickness");

1

CSV | Excel | XML | PDF

Your answer

Print

Get value from spreadsheet column to calculate Median

3

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

3.builder-style-0ca20b9b-d9b1-4c51-bcfa-6ab2b56252a4{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-935258bf-f0fe-40de-85d3-f0647a88a1e6{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

3

Your answer