Can we Pull Week of the Month?

Mukhilan
Mukhilan Member
in Charting

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

Tagged:

Best Answers

  • Jones01
    Jones01 Contributor
    Answer ✓

    @Mukhilan

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

    may do what you are looking for.

  • ArborRose
    ArborRose Coach
    edited August 2024 Answer ✓

    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)

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • MichelleH
    MichelleH Coach

    @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
    Jones01 Contributor
    Answer ✓

    @Mukhilan

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

    may do what you are looking for.

  • ArborRose
    ArborRose Coach
    edited August 2024 Answer ✓

    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)

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories