Agents
Category
Report Builder
Product Version
7.4
How can I aggregate my date/timestamp by MMM yyyy?
Answered
I have a timestamp column, and I want to return it as MMM yyyy.
It needs to aggregates by Month / Year, I don't want to see duplicate rows.
The same question
This is all done quite easily with the date converters found at the view level, and then applying a MMM yyyy format.
In this instance, you would want to convert your data to return unique month / year, but the same day date.
So using the Month Start Date converter, then formatting it as MMM yyyy will give you the results your'e after.
Step 1.
Apply your date converter choosing Month Start Date as the conversion and Format type.
Step 2
Format your column as MMM yyyy.
It's that simple!
Below shows the original column , converted column, then converted + format column
Please reach out to us if you have further questions on this, or run into any troubles.
Regards,
Yellowfin Support
This is all done quite easily with the date converters found at the view level, and then applying a MMM yyyy format.
In this instance, you would want to convert your data to return unique month / year, but the same day date.
So using the Month Start Date converter, then formatting it as MMM yyyy will give you the results your'e after.
Step 1.
Apply your date converter choosing Month Start Date as the conversion and Format type.
Step 2
Format your column as MMM yyyy.
It's that simple!
Below shows the original column , converted column, then converted + format column
Please reach out to us if you have further questions on this, or run into any troubles.
Regards,
Yellowfin Support
Replies have been locked on this page!