Best Of
Re: Maximum Number of Rows that Can Be Displayed on a Card
Hi @Tow, I believe you'll get an error if the rows, from the dataset, coming into the card are typically more 100,000, and if you apply filters (in ETL or card) and/or set a number limit in the Chart Properties (see below), it should display without issues.
This is an excerpt from here: https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs:
You can now use the Limits Row command inside of the Analyzer to set values larger than would otherwise be possible. To keep the responsiveness fast on your Dashboards, the chart engine limits the number of rows it downloads to the browser. Now you can override these limits by explicitly setting these values.
amehdad
Re: Use JSON Advanced Connector to POST to an API
Hi @simontarry76, if you haven't already, you should reach out to Support [support.domo.com] to have them look at it as well (and escalate to Dev if need be). They would be better suited to explore which part of the account credentials check is misaligning and causing the data to not come through.
amehdad
Re: How to change color and text size when using domo iframe?
Hi @ibtisamyyy, you could apply CSS styles to your iframe: https://stackoverflow.com/questions/217776/how-to-apply-css-to-iframe.
I would also advise on logging a ticket to Support [support.domo.com] as they can look into whether there's missing elements in your iframe or a bug causing the difference in appearance.
amehdad
Re: Data Warehouse Summary Values
Hi @Crisocir, 'Domo Magic Data' refers to the dataflows made up from multiple 'Data Sources' (for example, Salesforce connector data combined with Excel file connector data). From these dataflows created, you get your output datasets, which makes up the 'Dataset' number tile you can see.
amehdad
Re: Alerts on Output Dataset Fail with False Claim of Duplication
If you haven't already, you should raise the issue with your customer succcess rep and/or Domo support.
amehdad
Re: GA Advanced Connector and Domo (Demographics)
Have a look at your user permission settings, on the GA side, to see if that makes a difference on being able to bring in your data.
Alongside this thread, reach out to Support [support.domo.com] to have them look at it as well.
amehdad
Re: Query a DataSet: random "400: Internal server errors"
It doesn't appear that the Query API solution is fit for your use cases, due to the constant request load put on the server (even after limiting and offsetting). Have you reached out to Support [support.domo.com] to explore alternative solutions?
amehdad
Re: Email connector not working
For any issues like this, one should check if Domo is down or having problems [https://status.domo.com/] and/or open a ticket with support [https://domo-support.domo.com].
amehdad
Re: How to build card|total headcount based on the Hire date and termination date
Yep so as the beast mode above uses your two dates, you'll need a separate date field to create that month by month view. You can either use another date field in your 'Input' dataset (for example, dataset updated date), or can bring in a date field (like a daily employee log) from another dataset, via ETL and joining by ID Number, into your working one.
amehdad
Re: Email connector for Google Ads Report
Hi @Ainash, on your 2nd question, have a read of this knowledge article: https://domohelp.domo.com/hc/en-us/articles/360060270674-Google-Ads-Connector#4.0.1.
amehdad