How do I build a comprehensive project portfolio dashboard in Tableau using data extracted directly from Jira Software and ClickUp via REST APIs?
Download run
Fan-out diagram
The searches the AI actually ran for this prompt.
SEED QUERY
How do I build a comprehensive project portfolio dashboard in Tableau using data extracted directly from Jira Software and ClickUp via REST APIs?
3 real searches · 1 real-search pass
Jira Cloud REST API v3 issue search pagination fields documentation Jira Software Agile sprint endpoints officialGoogle ↗
OBSERVEDOther / navigational
ClickUp API v2 get tasks lists custom fields time tracked rate limits official documentationGoogle ↗
OBSERVEDOther / navigational
Tableau data model relationships extracts incremental refresh REST API official documentationGoogle ↗
OBSERVEDInstruction
Badge and edge weight = share of passes that produced the query. Hover a query for its intent and routing format.
Query classes
Google's semantic query class for every sub-query: what kind of answer each search is after, simulated vs real.
ChatGPT real searches (3)
Classes come from the query-classifier (a local Laya model). 3 of 3 calls are low-confidence (under 50%) — hover a query in the table to see its confidence.
Searches and sources
ChatGPT3 real searches · gpt-6
Jira Cloud REST API v3 issue search pagination fields documentation Jira Software Agile sprint endpoints official Google ↗
ClickUp API v2 get tasks lists custom fields time tracked rate limits official documentation Google ↗
Tableau data model relationships extracts incremental refresh REST API official documentation Google ↗
- Jira REST API documentation · developer.atlassian.com
- Jira Software Agile REST API · developer.atlassian.com
- ClickUp API documentation · developer.clickup.com
- The Jira Cloud platform REST API · developer.atlassian.com
- The Jira Cloud platform REST API · developer.atlassian.com
- Get Tasks · developer.clickup.com
- Get Task · developer.clickup.com
- Rate Limits · developer.clickup.com
- The Tableau Data Model · help.tableau.com
- Relate Your Data · help.tableau.com
- Extract Your Data · help.tableau.com
- Create Extracts on the Web · help.tableau.com
- Tableau REST API documentation · help.tableau.com
Queries
3 queries · click a column to sort
| Query / type | Search | Intent | Query class | Routing format | Cluster | Freq ↓ | Weight |
|---|---|---|---|---|---|---|---|
Jira Cloud REST API v3 issue search pagination fields documentation Jira Software Agile sprint endpoints official OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
ClickUp API v2 get tasks lists custom fields time tracked rate limits official documentation OBSERVED | Google ↗ AI Mode ↗ | — | Other / navigational | — | — | 1x of 1 | |
Tableau data model relationships extracts incremental refresh REST API official documentation OBSERVED | Google ↗ AI Mode ↗ | — | Instruction | — | — | 1x of 1 |