ColemenWilson Coach

Does your data have a date field that indicates when the ID was added?

You would have to do some work in ETL. I would create a recursive dataflow with a monthly snapshot. Then you could do a join of the current month in one branch and all other historical data in the other branch. Any ID's in the current month branch that don't find a matching ID in the historical data would be new ID's and…

This can all be done in a single ETL. Just go through the flow as you have in your head in Magic ETL and add the inputs along the way joining them as you go. You got this! Let us know if you get stuck!

Welcome to the Community @ColeStuart ! Is your hobby listening to podcasts or making your own?

I believe it is because of the OVER (PARTITION BY LastdayofMonth).

Yep, so as I mentioned you will have to join each row with every other row to check both columns.

Do you have any fields set in your sorting for the card? Also, is your total opportunities beastmode an aggregate function (sum, max, etc…)

You'll have to do some work in ETL and join each memo row with each reference number so you can compare the two values on the same row. Once filtered, you can use a group by to return the data to the proper granularity to use in your card. To join all data with all other data you'll need to use the add constants tile and…

We solved this. Even though card interactions were set right for the page, when a user clicks on the cells containing nulls it causes the table to go blank. This was fixed using the following beastmode: IFNULL(`Value`,'') This ensured that the cells did not contain nulls, but were still left blank to meet the dashboard…

Double check your settings on these cards. I've recorded a quick video that shows that this does not happen if the right settings are applied: https://www.loom.com/share/6f08293485344679b5222d696399c72e?sid=447cd274-a168-443f-aa4c-fdb053625699

What do you mean by the "self" card? You need to disable interaction filters on the table card by going to interaction settings for that card and then unchecking "Enable interaction filters"

Gotcha. This can be disabled. Just go to card interaction settings and uncheck the "Enable interaction filters"

Short answer is no. What are you trying to prevent? Changing the interaction to "Go to Card details" would expand the card when clicked, so no other interactions could take place on the card in the dashboard.

TIME_FORMAT((SUM(Talk time to decimal) / SUM(LIVE CONNECT count) ), "%H:%i:%s")

Is there a unique ID for each customer? Is there a field that indicates a cancellation? If there is a single date column that would mean that signup and cancellation dates would be on separate rows in which case you would need to do what @MarkSnodgrass pointed out. What you've shared is not enough information to do what…

If you could provide a few sample rows of data with sensitive information obfuscated the community could likely help you figure it out.

Without seeing your data or understanding its fields it is tough to know which fields you ought to use, however the calculation is pretty straightforward once you do: CASE WHEN `statusOfCustomer` = 'Active' THEN DATEDIFF(CURDATE(),`enrollmentDate`) WHEN `statusOfCustomer` = 'Cancelled' THEN…

No problem! Glad support got it figured out and this is good to know. I assumed since the data was showing in the preview this wouldn't be applied. I will check this troubleshooting in the future!!

Yep! Create a beastmode: CONCAT('<a href="tel:', `yourPhoneNumberField`, '">,`yourAnchorText`,'</a>') Use it as a field in a table card

Gotcha. As mentioned this isn't possible in default Domo, but you could probably build an app that has this functionality. What I would suggest, and I have done this successfully, is just mimic tabs look and behavior by making 3 buttons in the top left of the page and then replicating those same 3 buttons on all 3 pages…

@jessdoe yeah that is what I originally thought but looking at @muhammadtalha 's example in the original post it appears he is looking for a tabs experience within the page similar to what you'd see in Tableau. @muhammadtalha is this correct? Or do you just want to prevent a new tab from being opened in the users browser?

Ah gotcha. I believe this is only possible with Domo everywhere which I am not familiar with. Perhaps @GrantSmith can help?

You can link dashboards by creating buttons on your dashboard. You would create either an image or text card, and then change the card interaction in the dashboard settings to be a link to other content.

Do you have a shared files master list dataset for onedrive that shows every file that has been shared? This has helped us many times in troubleshooting these types of errors. Use the OneDrive for business connector and select the Shared Items report type. Then look through the data and see if your file is there. If not,…

Have you ensured that the excel file is shared with your OneDrive Domo account in OneDrive? And that the shared file name matches exactly including ".xlsx"? At my company we have a shared files master list dataset for onedrive that shows every file that has been shared properly to troubleshoot this exact situation.

It should look something like this:

Hi Shreeyab, add the quick filter in analyzer view and then make the selections to the right of the chart on the quick filter not in the filters section, then save and they will be the default while still giving the end user the option to change them.

This is definitely possible using the powerpoint plugin! You can customize which cards appear on which slides in the powerpoint. https://domo-support.domo.com/s/article/360043437953?language=en_US

Hi @Duc , this is actually already possible! https://domo-support.domo.com/s/article/360043437773?language=en_US scroll down to the "Editing the content for a report" section for steps on how to do this.