Use data as header
I have a data set that shows locations, event name, and date. I want to set it up kind of like a calendar, such that the date goes across the top as a header, locations are the column, and then under each date is populated with the event name.
Is there a way to do this?
so like this:
5/1 5/2 5/3
location event event event
location event event event
location event event event
Comments
-
The only way that comes to mind initially would be to create Sumo pivot table. Have the date field as your columns, the locations as your rows and the event populating the cells.
Anything else with the Table card would be static to my knoweldge and wouldn't be able to change with time.
Sincerely,
ValiantSpur
0 -
Excellent, that gets the layout I want, but it doesn't populate the cells with the event name. is there a way to get it to populate with the exact name?
0 -
Could you provide a generic sample of the data you're using? That would help me to know better what to tell you.
0 -
Sure I've added generic examples of what I want vs. what is there
0 -
Oh I misunderstood. Here's an example of the format of the data
0
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
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 412 Distribute
- 120 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive