Using date values for both x-axis and y-axis in chart
I have a dataset with a number of series (10-20) with two sets of dates that want to plot on both axis (see example below):
x-axis - update date (date a schedule was run to project anticipated finish dates - each series will have the same update dates)
y-axis - finish date (projected finish date for each series - date specific to each series and each update date)
Is there a way to produce this chart in DOMO? I've tried a few ways and DOMO indicates unable to process data.
milestone trend chart
First, I think this would be a great enhancement request. It doesn't look like it's currently possible to use a date value in both axes. That said, I have a potential, moderately tested workaround for you.
What I would do is create a new column that is a copy of one of the axes then convert it to a string. you could then use this to display the values and the original to sort and filter on.
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
I may be missing what you're trying to plot, but it sounds like a Gantt chart may work for what you want to visualize. This would give you a way of categorizing the series, and the chart will plot both the "start" and "end" dates of that series as a part of the project. Would that work for your needs?
If I have answered your question, please click "Yes" on my comment's option.1
Gantt chart works to visualize current schedule of tasks (one update) not to measure the trend of the completion of those tasks over multiple update periods. See image I posted originally for example.1
Did any of the replies help? If so can you click on "Accept as Solution"?
Hi @Jaketh13 , I took your recommendation and cast the date into varchar in tSQL before bring in DOMO. After doing this and put this varchar date on y axis, DOMO shows me nothing. Any idea why it doesn't work?1
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 182 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 77 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive