Hi,
Your help would be appreciated. I have the following query to display the unique opens . Unfortunately count distinct (for broadlog id)is not working. Is there any other way to achieve this.
var opensQuery = xtk.queryDef.create(
<queryDef schema="nms:trackingLogEventHisto" operation="select">
<select >
<node expr="countdistinct(@id)" alias="@opensCount" />
<node expr="[event/@journalDistributionID]" alias="@opensJD_id"/>
<node expr="date([event/@created])" alias="@opensDate"/>
</select>
<where>
<condition bool-operator="AND">
<condition expr="[url/@type]='2'" />
<condition expr="[event/@journalDistributionID] IS NOT NULL" />
</condition>
</where>
<orderBy/>
<groupBy>
<node expr="[event/@journalDistributionID]" />
<node expr="date([event/@created])" />
</groupBy>
</queryDef> );
Regards,
Priyanka