Hi nachiket.shinde.1981

nachiket_shinde · ‎2016-10-03

Hi Experts,

I have following data

I want Type wise, Max(Month_Number) wise, year wise avg. In this case 8.58006.

What expression should I write for this?

nagarjuna_kotha · ‎2016-10-04

Ue below exp :

Rate: Sum({<Month_number={'$(=min(Month_number))'}>}Rate)

Avg: Sum({<Month_number={'$(=min(Month_number))'}>}Avg)

Rooling sum : Sum({<Month_number={'$(=min(Month_number))'}>}RollingSum)

I hope this mat helps you.

-Nagarjun

sunny_talwar · ‎2016-10-03

Where are you looking to get this, text box object or chart? If it is a chart what all are going to you dimensions?

nachiket_shinde · ‎2016-10-04

Want to display in Bar chart Type wise, Max(Month_Number) wise, year wise

nagarjuna_kotha · ‎2016-10-04

Ue below exp :

Rate: Sum({<Month_number={'$(=min(Month_number))'}>}Rate)

Avg: Sum({<Month_number={'$(=min(Month_number))'}>}Avg)

Rooling sum : Sum({<Month_number={'$(=min(Month_number))'}>}RollingSum)

I hope this mat helps you.

-Nagarjun

shraddha_g · ‎2016-10-04

which chart you are using? what is expected output for this

rajpreeths · ‎2016-10-04

You can use expression FirstSortedValue(Avg,-aggr(Avg,Year,Month_number)) for the expected results.

Please refer the attachment and if the result is not as requested then please share dimensions details to be used in the chart.

Rajpreeth S

rajpreeths · ‎2016-10-04

Hi ,

I forgot to mention one point,

Type should be added in the aggr expression if you have multiple values for Type field in data model. ( For type wise data)

FirstSortedValue(Avg,-aggr(Avg,Type,Year,Month_number))

Rajpreeth S

sampada0810 · ‎2016-10-04

Use a straight table and apply sorting

How to get Sorted value?