Brick with Ten Datasets Question
Hey all,
In the template for the "Brick with Ten Datasets", is there more specific documentation on the queries used to pull summary info into the card?
For example, the https://developer.domo.com/docs/dev-studio-guides/data-queries link is provided as documentation for the code snippet below but there isn't even a reference to the types of aggregations (e.g. max=) used in the code.
var query1 = /data/v1/${datasets[0]}?fields=Costs&
max=Costs
; // Get the maximum value
Additionally, the linked documentation utilizes an entirely different format for querying (building a SQL statement through a series of variable declarations) vs the Brick - which includes a one-line condensed query. Feels like there should be more robust documentation somewhere including limits and capabilities for the way the queries were structured in the brick. (e.g. can one select a subset from the target table via a where statement in the one-line version?)
Any guidance would be appreciated.
Best Answer
-
There are two ways to interact with the Domo APIs, the first being a more object-oriented approach and the latter being url based approach.
This documentation lists out the different types of aggregation you can use in your query request:
It's not much but should highlight the possibilities for aggregation.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
There are two ways to interact with the Domo APIs, the first being a more object-oriented approach and the latter being url based approach.
This documentation lists out the different types of aggregation you can use in your query request:
It's not much but should highlight the possibilities for aggregation.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 640 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 767 Beast Mode
- 70 App Studio
- 43 Variables
- 715 Automate
- 185 Apps
- 460 APIs & Domo Developer
- 56 Workflows
- 14 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive