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

heriz over 10 years ago

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...

Discussion posts and replies are publicly visible

Parents

0 heriz over 10 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 heriz over 10 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data