Average check amount
Best Answer
-
Hi,
Try this layout:
Where BT_Date is the following Beast Mode:
CONCAT(MONTH(`Date`),'/',DAY(`Date`),'/',YEAR(`Date`))
Hope this helps.
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
Answers
-
Hi,
Try this layout:
Where BT_Date is the following Beast Mode:
CONCAT(MONTH(`Date`),'/',DAY(`Date`),'/',YEAR(`Date`))
Hope this helps.
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 -
@RGranada Just so I understand, what is gained by concating the date field like that?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Just did it to avoid having more than two dates in the x-axis....
If we just try to convert the date to a string, due to a currently identified Bug DOMO would still assume the Beast Mode as a data and show all the dates between the populated records.
Is there a better way to achieve it?
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.1 -
No, that makes perfect sense. If he wanted to graph the average check by week or month, or to be able to select the level of granularity, he would just keep the date field without the beastmode. The downside there is that when you are looking at the day view, he would also see any empty days in the x axis.
Thanks for the explanation!
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
thanks a lot, perfect!
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 435 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive