Aggregate function in prepare tab in lumira 2.0

[Former Member]

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?

[TammyPowlas]

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?

[Former Member]

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.

[TammyPowlas]

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