160647 - no subject - Hi All,\n\nI'm new to Appian and I'm hav

paulr866 over 9 years ago

Hi All,

I'm new to Appian and I'm having an issue with grouping. I want to be able to select a start and end date (date picker) and then group the data by day, week, and month (radio buttons).

I'm hoping to be able to do this via the timestamp which is in the format 2015-08-07 11:23:12

Can someone please advise on a way to approach this?

Thanks

Paul

Discussion posts and replies are publicly visible

Parents

0 paulr866 over 9 years ago

Hi lakshmim,

I have created a new report view and split the columns into day,week,month, and year as you suggested however i'm having trouble getting it to function with my radio buttons. i'm getting the following error

Could not display interface. Please check definition and inputs.

Interface Definition: Expression evaluation error at function a!queryAggregationColumn [line 67]: The a!queryAggregationColumn function has an invalid value for the “aggregationFunction” parameter. When “isGrouping” is null or false, “aggregationFunction” must not be null or empty.

I have inserted the following query. Can you advise what 'm doing wrong?

a!queryAggregationColumn(
field: "DayPart",
isGrouping: if(
rule!APN_isEmpty(
local!groupByFilter
),
{},
a!queryFilter(
local!groupByFilter = "Day",
True(),
False()
)
)
),

Thanks

Paul
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 paulr866 over 9 years ago

Hi lakshmim,

I have created a new report view and split the columns into day,week,month, and year as you suggested however i'm having trouble getting it to function with my radio buttons. i'm getting the following error

Could not display interface. Please check definition and inputs.

Interface Definition: Expression evaluation error at function a!queryAggregationColumn [line 67]: The a!queryAggregationColumn function has an invalid value for the “aggregationFunction” parameter. When “isGrouping” is null or false, “aggregationFunction” must not be null or empty.

I have inserted the following query. Can you advise what 'm doing wrong?

a!queryAggregationColumn(
field: "DayPart",
isGrouping: if(
rule!APN_isEmpty(
local!groupByFilter
),
{},
a!queryFilter(
local!groupByFilter = "Day",
True(),
False()
)
)
),

Thanks

Paul
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data