Hi All, There is possible to format field inside a!queryAggregationColumn f

Hi All,
There is possible to format field inside a!queryAggregationColumn function?
My script is like below:
a!queryAggregationColumn(
field:"dateTrans",
alias:"qt",
visible:true(),
isgrouping:true()
)

I want to format field 'dateTrans' from "dd/mm/yyyy" to "mmm yyyy".
This 'dateTrans' field stored in data store with data type of Date.
Thanks before.
Regards...

OriginalPostID-112860

OriginalPostID-112860

  Discussion posts and replies are publicly visible

Parents
  • Okay, can you help me provide the work around on this case?
    Below is my script:
    =load(
    local!data: queryrecord(
    recordType: cons!TransRecord,
    query: a!query(
    aggregation: a!queryAggregation(
    aggregationColumns: {
    a!queryAggregationColumn(
    field: "dateTrans", /* <----- want to show in mmm-yyyy format */
    alias: "label",
    visible: true,
    isGrouping: true
    ),
    a!queryAggregationColumn(
    field: "idTrans",
    alias: "data",
    visible: true,
    aggregationFunction: "COUNT"
    )
    }
    ),
    pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(
    field: "label",
    ascending: true
    )
    )
    )
    ).data,
    a!columnChartField(
    series: local!data,
    showDataLabels: true
    )
    )

    Thanks.
Reply
  • Okay, can you help me provide the work around on this case?
    Below is my script:
    =load(
    local!data: queryrecord(
    recordType: cons!TransRecord,
    query: a!query(
    aggregation: a!queryAggregation(
    aggregationColumns: {
    a!queryAggregationColumn(
    field: "dateTrans", /* <----- want to show in mmm-yyyy format */
    alias: "label",
    visible: true,
    isGrouping: true
    ),
    a!queryAggregationColumn(
    field: "idTrans",
    alias: "data",
    visible: true,
    aggregationFunction: "COUNT"
    )
    }
    ),
    pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(
    field: "label",
    ascending: true
    )
    )
    )
    ).data,
    a!columnChartField(
    series: local!data,
    showDataLabels: true
    )
    )

    Thanks.
Children
No Data