Aggregating using two fields from two different table

prathipsrinivas — Sat, 16 Nov 2024 02:50:27 GMT

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

Re: Aggregating using two fields from two different table

prathipsrinivas — Fri, 02 Aug 2019 07:24:22 GMT

Hey Guys,

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

Thanks,

Prathip