Best Of
Re: Creating a New column
@ColinHaze There are a couple different options you could use:
- You can reach out to your CSM about enabling a fiscal calendar in your instance. Here is a knowledge base article about how they work:
- You can upload a file to Domo with a row for every date and its corresponding month. Then you can join your data to that mapping table on date in MagicETL
Re: Missing Pagination Query Params for JSON Connector
That's what I was curious about. It can be a bit confusing but glad you got it working properly.
Re: Missing Pagination Query Params for JSON Connector
Is this only when you do the test of the connector or have you actually run the connector and it's requesting the same data multiple times?
Re: Missing Pagination Query Params for JSON Connector
Hi Grant
When I run the connector, I realized the pagination actually works. It is only under Settings → Parsing, both 'Pagination' and 'Parsing' tabs, when Domo makes an API call to fetch some data to preview in the browser, that the pagination query parameters are not included. In this case, it is a bit confusing - especially since there is a 'test' button next to a URL with pagination query parameters added, but when that 'test' button is pressed, a request is sent without pagination query parameters.
In our specific case, for backwards compatibility reasons, we have to return every single entry if no pagination query parameters are supplied, and this results in a "Response size too large" error for the endpoint in question, making the 'Parsing' settings impossible to use as data cannot be loaded.
Fortunately we were able to work around it by hard coding pagination query parameters under Data Selection → Advanced, then doing the configurations under 'Parsing', and then removing the hard coded headers.
Re: Need Tips for Optimizing Data Visualization in Domo
What are you looking to improve in your visualization?
Some general things I look out for when designing dashboards and cards is to pull in only the information that is necessary, the more data you're processing the slower your visualizations will load and respond to things like filtering.
Keep your dashboards simple, the more cards you have on a dashboard the longer it will take to generate everything.
Re: View as user or view as role
As a Domo admin I can see everything anyway so I am not sure why it would be a security issue. Agree with @JasonAltenburg that it should be a grant related to the admin role.
Re: How to Create WTD, MTD, QTD, YTD on one Chart
You can accomplish this at the ETL level. You'll need transforms for the WTD, MTD, QTD, YTD ranges along with calculations in each of those transforms aggregating your measurable fields.
jessdoe
Re: Create 'same' drill path for multiple cards
We put in an enhancement request to have this functionality. it woudl definitely be a time saver. No solutions yet but if any ideas please share.
Re: Bullet Chart - removing labels of Ranges
Thanks @jessdoe and @marcel_luthi, sadly they don't really work present the visual as I'd like - I think I'm going to keep it to hover text only 😅
I found that idea before posting this but I wanted to call out the specifics just to see if anyone had worked around this issue - @DavidChurchman 🤞 this one gets adjusted soon
Samuel.
Re: Is there a way other than SQL to cross-join two tables (Cartesian Product)?
I think you would be better off doing the SQL step, but I think it is possible in ETL as follows.
I utilized the tables from the cross join example on w3resource here
After adding these tables using excel upload to function as inputs, I used add constant to the company table of an ITEM_UNIT column containing string 'Pcs', to match the ITEM_UNIT field in the foods table.

I then did a full outer join on the ITEM_UNIT field.

I then did select columns to only return the desired fields of ITEM_NAME, ITEM_UNIT, COMPANY_NAME, and COMPANY_CITY.
This produced what I believe is the desired output.

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'


