Aggregating using two fields from two different table

[prathipsrinivas]

Hi Experts,

I want to aggregate a field like Count(Event) on two fields Date and Guestname which is coming from two different tables, in script itself.

I know it is simple as Aggr(count(Event),Date,GuestName) in chart Expressions.

The reason is being, I want to use values of the resultant aggregated field as condition for chart expression.

Something like , I create variable just to assign some integar and use that in a button object to pass the value in a chart expression.

Any other work around or suggestions are also very welcome.

Thanks in Advance,

Prathip

[prathipsrinivas · Accepted solution]

Hey Guys,

I have done it the chart itself by creating a Calculated dimension for Guest Name to pass the variable.

Thanks,

Prathip