Please Help Me

[rajveersinghsisodiya]

hi i need to create some table or chart like specified below:- 

Field NAme	Avg	Stdev
Name_of_field_1	10.2	2.5
Name_of_field_2	15.76	4.6
Name_of_field_3	16.56	5.6

all this feilds are from one table. 

[#2]

Do u have avg and stDev available or u want to calculate it.

What is the problem you are facing in creating above table

[alexandros17]

Load

[Field Name],

stdev(myField) as StandardDeviation ,

avg((myField) as average

from abc.xlsx group by [Field Name];

let me know

[#4]

If u have already calculated then simply u can use table box

[avinashelite]

Hi Rajveer,

Use Straight table Chart, in dimension give your field name and in expression write Avg(filed name)

and add second expression , definition as Stdev(filed name)

[Gysbert_Wassenaar · Accepted solution]

Create a calculated dimension:

• =valuelist('Name_of_field_1','Name_of_field_2','Name_of_field_3')

and two expressions:

• pick(match(valuelist('Name_of_field_1','Name_of_field_2','Name_of_field_3'),'Name_of_field_1','Name_of_field_2','Name_of_field_3'), avg( Name_of_field_1),avg( Name_of_field_2),avg( Name_of_field_3))
• pick(match(valuelist('Name_of_field_1','Name_of_field_2','Name_of_field_3'),'Name_of_field_1','Name_of_field_2','Name_of_field_3'), stdev( Name_of_field_1),stdev( Name_of_field_2),stdev( Name_of_field_3))

[rajveersinghsisodiya]

it not calculated i need to calculte it.

[rajveersinghsisodiya]

data is already loaded and i need to calculate it with writing expressions.

[avinashelite]

Can you please post your qvw file

[#10]

use straight table

Dimension - FieldName

Expression - Avg(Field)

Expression2-stdev(Field)