How to display inventory total value over the past 5 days

LeonN
LeonN Member
in Charting

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

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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 <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

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

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • GrantSmith
    GrantSmith Coach

    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!**
  • MichelleH
    MichelleH Coach

    @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
    LeonN Member

    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
    MarkSnodgrass Coach
    Answer ✓

    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 <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • LeonN
    LeonN Member

    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
    MarkSnodgrass Coach

    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 <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • LeonN
    LeonN Member

    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.

    Screenshot 2023-09-07 125207.png

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

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

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories