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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive