GrantSmith Coach

Instead of keeping this logic within a beast mode I'd recommend using another dataset (Excel upload, Webform etc) with each of the different plant types and their goal for the day of the week and then use an ETL to left join your dataset to the goal dataset and then using a coalesce in a formula tile to set a default goal…

Hi @Fatias I'd recommend setting up a date dimension dataset and creating your own PoP card to give you more flexibility. I've done several videos and writeups on this. You can read more on it here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

Are you using a MySQL dataflow or a Magic ETL data flow?

Are you wanting to have the iframe clickable and take you to a new domo page or are you wanting a link/text inside your iframe to go to the new page?

Do you have some anonymized data you can share t o better understand your data structure?

Try something like this CASE WHEN SUM(`Open qty`) > SUM(`onhandunits`) + SUM(`openpoqty`) THEN 1 ELSE 0 END

Does your card display properly when editing your drill path? Do you have any beast modes on your drill path card that would reference a column which no longer exists?

Hi @gabriellegeither It's a bit difficult to do this with a beast mode. I'd recommend utilizing an ETL and the Dynamic UnPivot tile to transpose your data. You can read on these here: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#4.

Hi @svetlana You can use a different dataset in your drill path card however if you wish to have the filter applied to the drill path card your filter field needs to be named the same within the two datasets.

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?