error in documentation of weekday beast mode function
I think the documentation for weekday function in beast mode is not compatible with its behavior in the documentation.
"WEEKDAY
Returns the numerical day of the week for all values in a date/time column (e.g. '0' for 'Monday').
WEEKDAY('DateCol')"
but when I created a card I get this result which shows number from 1 to 7, 1 is for sunday.
I think the documentation should be updated.
Comments
-
I submitted a similar request probably two years ago when I worked for Domo. I guess it still hasn't been fixed...
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Doesn't the value returned by Weekday depend on the instance configuration(first day of the week), or time zone settings?
I made a quick test and I'm getting 7 for Sunday...
Furthermore, it seems to me that WEEKDAY as been deprecated in favor of DAYOFWEEK, I can't even find WEEKDAY on the documentation anymore (not on this link for example http://knowledge.domo.com?cid=beastmodereference )
Regards,
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Now that you mention DAYOFWEEK and WEEKDAY together, my previous ticket with Domo was regarding these two functions comparatively. They used to display the same value, even though that beast mode editor function description indicated one was 0 start and the other was 1 start, but they were functionally identical. Sorry for any confusion.
I'm not certain how Domo regulates time-based beast mode outputs here with vertica but apparently it can be different across instances. @sia is right, the function description should match the function output.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive