Can we Pull Week of the Month?

Mukhilan

Hi There,

I need week number of the month, as in Domo I don't find any inbuilt function for this like WEEKOFYEAR.
For Instance :
Spend for week 31 (July 28 to August 3) is $100,
I want two rows coming under each month and the week for july should be 5 and its spend of only july dates and for august Week should be 1 and has only augusts date spend.

Let me know if there is any calculation that can help me on this.

Thanks

Jones01

@Mukhilan

FLOOR((DAYOFMONTH(datecol) - 1) / 7) + 1

may do what you are looking for.

ArborRose

As Jones01 says, either of these should work

FLOOR((DAY(`date_column`) - 1) / 7) + 1


FLOOR((DAYOFMONTH(`date_column`) - 1) / 7) + 1

Create a Table or Chart in Domo.

Add the fields:

YEAR(date_column)
MONTH(date_column)
Week Number of Month as shown
Total Spend: SUM(spend_column)

MichelleH

@Mukhilan I'd suggest calculating the "Week of Month" using the Calendar dataset from the Domo Dimensions Connector, then joining by date into your spend dataset

Jones01

@Mukhilan

FLOOR((DAYOFMONTH(datecol) - 1) / 7) + 1

may do what you are looking for.

ArborRose

As Jones01 says, either of these should work

FLOOR((DAY(`date_column`) - 1) / 7) + 1


FLOOR((DAYOFMONTH(`date_column`) - 1) / 7) + 1

Create a Table or Chart in Domo.

Add the fields:

YEAR(date_column)
MONTH(date_column)
Week Number of Month as shown
Total Spend: SUM(spend_column)