GrantSmith Coach

Hi @HalD This appears to be a duplicate and I've posted an answer on your other question: https://dojo.domo.com/discussion/54952/can-anyone-help-me-understand-how-to-create-dynamic-text#latest

Hi @Saketh Have you looked into implementing a Fiscal Calendar from Domo? https://domohelp.domo.com/hc/en-us/articles/360042924254-Using-a-Fiscal-Calendar

@pratikrrana I'd recommend breaking your SQL down into chunks. Start by looking at what's being returned from your first query: SELECT GROUP_CONCAT(DISTINCT CONCAT( 'sum(case when x.question_text = ''', question_text, ''' then x.answer_text end) AS ', question_text, '`' ) ) from (SELECT DISTINCT…

You could utilize a Magic ETL to split out the lab classes and the lecture class, calculate the lecture class out from the lab class course code, join the two datasets together based on the lecture code and username then use a combine column tile to join your two columns together (alternatively you can use a formula tile…

Since this appears to be an issue with the connector itself you'll want to log a support ticket with Domo and they can help investigate the error on their end. Alternatively have you tried recreating the connector with the same settings?

Hi @jcrouse Currently there isn't a way to add anchor tags / section links within a Domo page. I know this has been asked for before several times but nothing appears to have come from these closed idea requests: I know the product team is taking a closer look now at ideas in the idea exchange so I'd recommend opening a…

This one was a bit tricky and fun and I spent way too much time on this. I ended up doing this in a Magic ETL2.0 formula tile and building off of the different components. I'll break it all down below and at the bottom will be the ETL code you can copy and paste into the new Magic ETL which should have it all for you.…

I think an easier option would be for you to utilize a beast mode and put that into a text card to display with a message telling the user to select a single campaign if they have more: Beast Mode: CASE WHEN SUM(1) > 1 THEN 'Please select a single campaign' ELSE MAX(CONCAT(`Campaign name`,' is ',`description`,' and…

You'll need to do your calculations within snowflake as Domo can only read data from a federated connection and not performa any ETL on that data.

@HGV Have you confirmed your credentials are correct and that those credentials have access to the search id?

This sounds like a bug. I'd recommend logging a ticket with Domo Support about the issue.

@Nick12 How is your JSON API endpoint telling you about the pages? Have you configured your connector to use that same type of pagination method?

@user049141 This sounds like a bug with the policy auto creation. I'd recommend submitting a ticket with support.

@HalD Is your filtered data returning a single record or are the campaign name, description, start date and status all the same value after filtering? If that's the case taking the MAX of those values will give you the same single value allowing you to display it correctly on your page.

Seems like dynamic page filtering isn't available with the waterfall chart currently then. I'm not certain if this is intended or a bug but you could try and reach out to Domo Support to get a definitive answer.

You can utilize a notebook card on a page and insert dynamic text directly into the notebook using a several summary numbers. When editing the notebook card you can click on the [#] button in the toolbar to insert a summary number. Since it is a summary number you'll likely need to use a min or max on your string fields…

When you click on the waterfall card to filter on your page is there a blue box with a left facing arrow that appears on your waterfall chart? Are there any page filters being applied atop the page?

Does the email address field you're using to join the tables together have the same values in both fields? Can you look at one where the additional data is missing in your master dataset based on the email in the report dataset and see if you can find the same email in the master dataset?

Sounds like a bug. I'd open a ticket with Domo Support if it's doing an Append even though it's set to Replace.

1) Are you using the same column name from the waterfall as other charts on your page? 2) Do you have any card interaction limitations on the waterfall to not apply the filter to the rest of the page?

Do you have some sample anonymized data you could post so I can get a better understanding of your data structure? Any perhaps what you want your output dataset to look like?

Seems like an issue with your CRM system itself in that it can't read information. Are you able to pull the data normally through the CRM UI and is this only an issue when attempting to pull the data via the API / JSON No Code connector?

I was hoping it mirrored the pydomo package but doesn't appear to be the case. What you could do is configure an ETL to do a recursive append every time your rdomo dataset is updated in Domo. Creating a Recursive/Snapshot DataFlow in the New Magic ETL

This is because of using a LEFT join on your dataset. What you're saying is give me all the records in my report table and then give me related information int the master list table if it exists. If you want to get all the data from your master list and supplement it with your report list then you'd need to use a RIGHT…

This is currently how Domo functions. You'd need to share all the pages with the admins (or dynamic group of admins) so they have access to all of the pages.

Have you tried passing in 'APPEND' as the update method parameter in your ds_update function?

In typical Windows fashion - have you tried restarting your workbench server?

You would utilize a Domo Web Form and update your data there and then use an ETL to join it to your original dataset but currently you can't do it within cards.

You'd bring in the dataset that's already in Domo, compare to the records you wish to update and filter out the ones you don't want. You'd only be importing the updated partitions into Domo and Domo would have the existing dataset already on hand The only way Domo can handle removed records is to do a full replace or a…

Have you looked into using a recursive dataflow to "partition" your data and filter out any old records and replace them with new records? https://domohelp.domo.com/hc/en-us/articles/360057087393-Creating-a-Recursive-Snapshot-DataFlow-in-the-New-Magic-ETL If you're using workbench have you looked into partitions?…