calculate exactly like Pivot tables in sql
Hello,
I have sanpshot coming daily which gives the information of how and what sales we did for that day and it all formulates under ship to fiscal week, year , product, invoices, amount, etc.
So what shall be my best approach to make it automated. I know we have distinct function in SQL which gives me quick win, so I dont have to manually and sort the unique invoices and calculate that particular Product under it. What shall be my best approach and which charts I shall formulate this kind of forecasting. Do anyone have exposure to make it in story telling dashboard ?
my daily snapsot looks like this,
Also my user like to see historical data from 2015 and going forward.... Also they are comparing their data with targets they set starting of each year( which is hard coded).
Comments
-
Its not clear what you are trying to do here. You mention automating, what are you trying to automate? Are you trying to save the snapshot infomation in a table (automating this task)? Some more information will help in answering this part.
If you have targets for these numbers, I would use a bullet chart for displaying current year's data against last year's data and the target. This way it tells you a story of how your sales are doing compared to the target and to that of last year.
0 -
@rahul93 Business is manually calculating the Sales every week and putting it in excel dashboard. How can I do similar calculations in Domo. Pivot tables consists of :
1. Ship Fiscal Week Number
2. Unique Invoice-
3. Product category
4. Total of each product
How can I formulate this in magic ETL/ SQL.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive