Aggregate a date column

Mat Chabros shared this question 2 years ago
Answered

Hello Yellowfin Community team!

Yet again, I encountered a problem that I cannot go around (apologies if it is a simple problem and easily solvable).


462d9ff0d6738d59b35f578bdea88743

Please see the screenshot I've attached. How can I aggregate the values so I do not see them separated just as in that screenshot? I want to see a sum for every month, I will also want to see in week numbers as well.

Best Answer
photo

Hi Mat,

It looks like you are only formatting the looks of the date column to be months, and that the underlying field is still a date field which will have many values that cannot be aggregated. I would recommend using view level "date functions":

http://wiki.yellowfin.com.au/display/USER74/Date+Functions

Since this is a dimension seperate from the underlying dates, you will be able to aggregate against it.

Let me know if this makes sense.

Regards,

Nathan

Comments (1)

photo
2

Hi Mat,

It looks like you are only formatting the looks of the date column to be months, and that the underlying field is still a date field which will have many values that cannot be aggregated. I would recommend using view level "date functions":

http://wiki.yellowfin.com.au/display/USER74/Date+Functions

Since this is a dimension seperate from the underlying dates, you will be able to aggregate against it.

Let me know if this makes sense.

Regards,

Nathan