Filtering table by selecting from chart - or showing hover text

I have a dataset with data along the lines of:
UserID - Order Date - Order Number - Customer Name - User Purchase # etc.
I have a chart to show first time purchases by users (where user Purchase # = '1'). and then a table below to provide more information on the customer. Is there a way to filter the table by the users when I click on a particular par? For example, if I click on the 2022-Dec bar in the "First time purchases by Users", is there a way to filter the table below by just those two users?
Or... is there a way to provide the UserID/information in the hover text? I tried using ToolTips and it blew up my chart...
I ha
Best Answer
-
Your bar chart is being aggregated so when you attempted to add in user information it included all records as it now had to deal with the additional user information to group on. When you click on the 2022-Dec in your First-time purchasers Domo only knows about the value you selected which is the date. It doesn't know about the first-time purchasers to filter your table below. You'd need to have another table for just first-time purchasers.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Your bar chart is being aggregated so when you attempted to add in user information it included all records as it now had to deal with the additional user information to group on. When you click on the 2022-Dec in your First-time purchasers Domo only knows about the value you selected which is the date. It doesn't know about the first-time purchasers to filter your table below. You'd need to have another table for just first-time purchasers.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 645 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 773 Beast Mode
- 74 App Studio
- 43 Variables
- 727 Automate
- 186 Apps
- 466 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive