How can I aggregate my date/timestamp by MMM yyyy?

Yellowfin FAQ shared this question 2 years ago
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.

Comments (1)

photo
1

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.

11f1696509316f2576142b6d44b6c6e1

Step 2

Format your column as MMM yyyy.

61e91ade99e646d96b39b5a6a0bed3a6


It's that simple!

Below shows the original column , converted column, then converted + format column

4ce5dc5129e58f5500f163a912245908


Please reach out to us if you have further questions on this, or run into any troubles.


Regards,

Yellowfin Support