How to display inventory total value over the past 5 days
I'm looking to show how the total value of our inventory has changed over the past 5 days. Ideally it would be a bar graph showing the rise and fall of inventory value depending on what's been sold/purchased over the past week.
I believe I have all the data I need in Domo, I just need to figure out how to create the card.
Best Answers
-
You can create a beast mode that multiplies cost * qty and then put this in the y-axis of your card and choose sum. Put your date in x-axis and choose last 5 days in your date range filter.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
In the date range filter, change your Graph By to Day instead of Year.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
What does your data structure look like? Do you have separate columns for bought and sold based on each day or do you have one row for each sold and purchased along with the date?
Do you have a starting inventory number?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
The table I have has the following columns:
Cost - cost of each piece
DateCreated - the date that each piece was entered
Qty - either 1 or 0 (every piece of inventory is different)Let me know if this helps or if you need more info!
0 -
You can create a beast mode that multiplies cost * qty and then put this in the y-axis of your card and choose sum. Put your date in x-axis and choose last 5 days in your date range filter.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Okay, I'll try that. I have a couple outliers in my data set with a lot higher qty values. Is there any way to filter those within beast mode?
0 -
yes. you can do this a couple different ways.
Option 1: You can drag the quantity into your filters and filter to less than a number you think would exclude outliers.
Option 2: You could add a case statement to your beast mode that only will do the math if the quantity is less than a certain amount. i.e. CASE WHEN qty < 1000 THEN qty*cost END
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I might of done something wrong here, instead of showing the last five days on the x axis, it's just showing "2023" and giving me one data point.
0 -
In the date range filter, change your Graph By to Day instead of Year.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive