How to display inventory total value over the past 5 days

LeonN

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.

MarkSnodgrass

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.

MarkSnodgrass

In the date range filter, change your Graph By to Day instead of Year.

GrantSmith

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?

MichelleH

@LeonN Can you please share some more information about the data you already have in Domo? The solution will be different depending on how inventory is measured in your data

LeonN

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!

MarkSnodgrass

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.

LeonN

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?

MarkSnodgrass

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

LeonN

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.

MarkSnodgrass

In the date range filter, change your Graph By to Day instead of Year.