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

The format of the date is associated with the locale (e.g. en_US vs en_GB) the closest you can get to mmm yyy is mm/dd/yyyy if your users set their preference to en_US

Hi Eduardo, thanks for your response. For this case, as we know we can format the date field using text() for getting result with "mmm yyyy" format (text(dateTrans, "mmm yyyy")).

But, we got the issue when we want to show grouping data in Tempo Report.
We want to show Column Chart with source from data store. And in my data store, dateTrans stored with date format.

There is any work around for showing report with formatted grouped data ? (Dimension : dateTrans (Month Year), Calculation: count IdTrans )

Thanks you.

The queryAggregationColumn doesn't take any formatting

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.

Hi all, anyone have a solution for this case? Thanks a lot.

As the queryAggregationColumn does not take any formatting, there would be no work around except to use have the user's set their locale to view the data accordingly as Eduardo recommended above.

Another alternative is to handle the aggregation by creating a database view to aggregate your data in the desired date format.