Comparison of data in Graph from different Dates

Hello Beautiful People!
Need your input on how I can compare data from different dates
basically, we have 3 columns, the acct numbers, sales and dates
it is a basic daily upload of data, which means that we get the same acct number more or less, and new sales per day for the same acct numbers on different dates
what I need to see is a table that has the columns > acct numbers dates and sales
attached the sample file that shows the raw data
Output Graph should be >>>
Acct Numbers > 6/2/2020 > 6/3/2020 > 6/4/2020 > Difference
12345 12 12 13 1
12324 9 9 6 -3
12335 3 8 25 17
thank you for all your inputs!
Comments
-
It sounds like you could use the Pivot Table chart (Under Chart Types > Tables and Textboxes > Pivot Table) with the Account Numbers being your rows, Dates being your columns and Sales being the value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive