calculated Dimension

[samuel_brierley]

Hi can anyone see why this would evaluate to there are no numeric value on the X axis?

Avg({$< Name = {'MainCarriagewayDataFilteringOutput.site2.o'}>} Value)

value is obviously a number.

I have tried using this formula as an expression and its fine

[manideep78]

If you want to specify aggregation functions in calculated dimension then you should have to give aggregator....

Try like this:

Aggr(Avg(YourAverageField),YourAggregatorField)

[samuel_brierley]

Hi all.

I think I know the issue but im unsure how to fix it.

the way that my data is arranged is as such

'Time'	'Type'	'Name'	'Value'
00:00		'MainCarriagewayDataFilteringOutput.site2.o'	1
00:00		'MainCarriagewayDataFilteringOutput.site2.q'	2
00:01		'MainCarriagewayDataFilteringOutput.site2.o'	3
00:01		'MainCarriagewayDataFilteringOutput.site2.q'	4
00:02		'MainCarriagewayDataFilteringOutput.site2.o'
00:02		'MainCarriagewayDataFilteringOutput.site2.q'
		'MainCarriagewayDataFilteringOutput.site2.o'

so what i want essentially is at time 00:00 I want a point on the table with 'MainCarriagewayDataFilteringOutput.site2.o' as the dimension and 'MainCarriagewayDataFilteringOutput.site2.q' as the expression.

Im not sure how to tackle this, thanks for any help

[#4]

Why you try with calculated dimension? Maybe you need it as expression?