Total.countDistinct function syntax with grouping [message #261581] |
Fri, 16 November 2007 19:38 |
No real name Messages: 3 Registered: July 2009 |
Junior Member |
|
|
I am trying to use the Total.countDistinct function and I keep getting an
error. The error is:
Wrong group expression for aggregate function COUNTDISTINCT
My report query is:
SELECT
task_key,
hour_in_day_key
FROM
f_task
WHERE
month_key = 1
AND day_in_month_key = 1
This produces a dataset with a column of integer values (task_key) that
correspond to integer hours of the day (hour_in_day_key).
I have created a computed column (actually several attempts) attempting to
count up task_keys for each hour. The javascript that I have come up with
is listed below:
hour = row["hour_in_day_key"].valueOf();
Total.countDistinct(row["task_key"],Total.NO_FILTER,hour);
I am using BIRT 2.1.2 and am hoping someone can help me with the proper
syntax for the Total.countDistinct function.
|
|
|
Powered by
FUDForum. Page generated in 0.02578 seconds