Skip to Content

Aggregate function in prepare tab in lumira 2.0

Oct 12, 2017 at 07:05 AM


avatar image

I am using lumira 2.0. I need to create a new measure that uses aggregate functions like sum, average in prepare tab.But i don't find any options for the same. Is there any way to do column-wise aggregation in lumira 2.0. Can someone help me in solving this problem?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Oct 12, 2017 at 09:49 AM

Hello Bharath,

Are you using Lumira Discovery?

For columnwise subtotals, have you tried the crosstab and totals as shown below?

Can you explain a little more about the measure you are trying to create?

1bharath.jpg (80.3 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

Yes, Tammy, i am using Lumira Discovery 2.0

I have tried Crosstab feature in DesignView. But for my requirement, I want to create new measures in DataView and not in DesignView.

I want to create a measure similar to the below table in DataView

New Measure = If Date1>Average(Date2) then True else False

Finally, I will be using this data prepared in DataView for my visualization in DesignView.

sample.png (5.0 kB)

Bharath - I can't get this to work; I will keep thinking about this though. Maybe the community has ideas