-
Carrying date range in hyperlink
I am using pfilters to drilldown on multiple columns. But the set date range isn't carrying when the link is clicked. How can I open an anchor link so the new page has the date range the first page had? CONCAT('<a href="https://domain.domo.com/page/1234567898?pfilters=' etc
-
Filter on two or more columns
Do pfilters require special configuring of python or something? I want to embed an anchor reference link, to open a drill through page filtered on two or more columns in the row that was clicked. In the example below, clicking the link on the first row would open a page filtered on store=5, salesperson=Ralph. Store…
-
Standardizing Names
I need a way to apply a list of replacement values against incoming data. This is to standardize naming on insurance companies. If the data field says "BCBS of Tennesee", "BCBS of Tennessee", "BCBS of Tenn", Blue C Blue S", etc…the result needs to be in a new field with the result "Blue Cross Blue Shield". Say I have an…
-
Domo API to MS-SQL
I tried unsuccessfully to find an example of pulling a Domo dataset directly to MS-SQL via the API. So I created my own. I am not a python coder but my script works just fine. Does anyone have a version of this subroutine that does not require defining the column names (ie header)? #Retrieve dataset from Domo API def…
-
Card Lineage
A previous question asked how to find the dashboards that use a given card. The answer pointed at using Domo Governance reporting. Surely there's an easier way to connect the dots. If I open a dataset, there's a "cards" link that shows me the cards that use the dataset. When I click on one of the cards…is there no way in…
-
Format as number without comma
I have a new version of an existing dashboard. The dashboard has a dropdown selector for year. Year is a formula field on the ETL defined as Year(`transaction_date`). On my original dashboard I see 2023, 2022, 2021. On the new version, I can't get the filter to remove the thousands comma. So I see "2,023" instead of…
-
Remove answered questions from the list of unanswered questions
Why are answered questions coming up in the unanswered questions link? Can we get those removed from that list?
-
Show Scheduled Connectors
Is there any way in Domo to see the time schedule for all jsn or other connectors? I want to review the times I have set for connectors. Currently I use an external site to keep notes.
-
Export to PDF error - images
I have a dashboard that displays information with a field containing a person's id. On one of the cards, I display an image of the person. The card uses an html table to display the person by calling an image url. When I try to export the dashboard to PDF, the export fails. If there any way to tell Domo to ignore a card…
-
MySQL Workflow
Can Domo's mysql handle more than 500k records? It shows the import can only go to 500k but I'm assuming that is for previewing data not actual processing. I attempted to output only five rows from a million record dataset and it ran for 30 minutes before I cancelled the process.
-
CLI move-data needs to move not copy
Using the CLI move-data command, I set up a dummy dataset to move rows. The rows copied but did not remove from the source.
-
Allow empty datasets with future date ranges
We pull two years transactions plus the current year from an api using JSON connectors. I've found it more reliable and efficient to break the data into smaller pieces. For the past years, I have created a connector for each - refreshed once per month. For the current year, I am splitting the year into Q1, Q2, Q3, and Q4.…
