Running Customer Value
I am trying to build a card that show our customers' running total value (for the last 365 days).
Here's the BM I have right now:
SUM(CASE WHEN `SO Ship Date`<=`SO Ship Date` AND `SO Ship Date`>SUBDATE(`SO Ship Date`,INTERVAL 365 DAY) THEN `SO Item Total Amount` ELSE 0 END)
Obviously though, when I graph it by month, I'm only getting the sum from the orders in each month. I would like to see the running total, just as of that month.
The ultimate goal of this is to see our different sales channels success, or more so, the health of their databases.
Any ideas?
Best Answer
-
I ended up using an ETL to restructure the data as needed
0
Answers
-
Hi,
Have you considered using one of the running total graphs?
Running Total Bar Graph:
http://knowledge.domo.com?cid=runningtotalbar
Running Total Line Graph:
http://knowledge.domo.com?cid=runningtotalline
Running Total Stacked Bar Graph:
http://knowledge.domo.com?cid=runningtotalstacked
Running Total Grouped Bar Graph:
http://knowledge.domo.com?cid=runningtotalgrouped
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 -
No, that doesn't quite work.
I can see how each channel is doing currently. But I don't see any trends.
The goal would be to see the running total each month, at the same time.
For instance...
(we sell bar & wine accessories)
During Q4 I would expect our Liquor Store channel to increase in value.
During the spring, I would expect to see Wineries have a higher value since that's a big season for them.
0 -
I'm sorry can't quite understand your need.
Can you draft the chart you are aiming for?
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 -
Yah, I know it's tricky.
See attached. That's kinda what I'd expect (it's using the aforementioned formula), accept the values should be much higher.
0 -
I am sorry I must be missing something...
Isn't that the same as having the SUM of Costumer Value by month for Ws, Makers and Gift?
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 -
I ended up using an ETL to restructure the data as needed
0 -
Hi, would you mind sharing the ETL . I am facing same challenge to create Running total by month.
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