zaclingen_zips

Thanks for the feedback. I get it now. I feel like it might be worth including that detail in the function's description within MagicETL. This isn't the first time a lack luster description in there has stirred me wrong.

in Bug / Incorrect behavior with Convert_TZ() in MagicETL Comment by zaclingen_zips August 2023

That is awesome! Nice to see that Domo employees watch these threads. Appreciate you hopping on the topic and acting quickly

in WEEKOFYEAR() should be removed from the approved function list or it's behavior should be changed Comment by zaclingen_zips June 2023

Have you tried using a Beastmode to complete this? I feel like you could create a calculated field for Gross Profit pretty easily. Unless I am misunderstanding your goal.

in How to add gross profit row into profit and loss pivot table Comment by zaclingen_zips June 2023

This idea has been tossed around ever since BeastModes were released lol Happy to see that it is finally coming (per another comment)!

in Reuse Beast Mode field in another calcuation Comment by zaclingen_zips June 2023

WEEKOFYEAR('2023-06-19') should return 25 but WEEKOFYEAR('2023-06-18') also returns 25. WEEKOFYEAR('2023-06-17') returns 24. According to that testing, WEEKOFYEAR() assumes the week starts on a Sunday, but the documentation on w3schools that you shared states that the function assumes the week starts on a Monday per MySQL…

in WEEKOFYEAR() should be removed from the approved function list or it's behavior should be changed Comment by zaclingen_zips June 2023

zaclingen_zips Member

Comments