Mukhilan

Discussions

Can we Pull Week of the Month?
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…
STR_TO_DATE throwing Parsing error in ETL
I am facing a error while converting string to date. This process is done in the ETL Date column has value - Jun 11, 2024 @ 14:33:22.000 Formula - STR_TO_DATE(@timestamp, '%M %e, %Y @ %H:%i:%S.000') The error showing is as attached below Note : We receive data using email connector. Please let me know where it is going…

Can we Pull Week of the Month?
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…
STR_TO_DATE throwing Parsing error in ETL
I am facing a error while converting string to date. This process is done in the ETL Date column has value - Jun 11, 2024 @ 14:33:22.000 Formula - STR_TO_DATE(@timestamp, '%M %e, %Y @ %H:%i:%S.000') The error showing is as attached below Note : We receive data using email connector. Please let me know where it is going…