List 2 Time Periods in a Table
Hello,
I need to list 3 categories for 2 different time periods in a table. See attached sample. I cannot find any instructions on how to accomplish that. Can anyone point me in the
right direction or share their knowledge?
Thanks!
Best Answers
-
Depending on how your data is structured, you can use the pivot table chart to do this. Put your date field in the columns section and then your Interest Earned, Net Book Balance and Accrued Interest in the values section and your account number in the rows section. You can use the date range filter and graph by to group the data by month if necessary.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@MarkSnodgrass Thanks! I will try this out.
1 -
@BethW to add to what @MarkSnodgrass has provided, I would also encourage you to check out "Trellis Charts" if you are looking to visualize this data in addition to having the table.
Check this KB article under the heading: "Adding additional categories as series ("trellis chart")"
1
Answers
-
Depending on how your data is structured, you can use the pivot table chart to do this. Put your date field in the columns section and then your Interest Earned, Net Book Balance and Accrued Interest in the values section and your account number in the rows section. You can use the date range filter and graph by to group the data by month if necessary.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@MarkSnodgrass Thanks! I will try this out.
1 -
@BethW to add to what @MarkSnodgrass has provided, I would also encourage you to check out "Trellis Charts" if you are looking to visualize this data in addition to having the table.
Check this KB article under the heading: "Adding additional categories as series ("trellis chart")"
1 -
@JasonAltenburg thanks!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 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
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 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
- 109 Community Announcements
- 4.8K Archive