ColemenWilson Coach

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:

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.

Hi @Duc , this is actually already possible! scroll down to the "Editing the content for a report" section for steps on how to do this.

@amehdad WOW! This is excellent. Thank you so much for the recommendations. National Parks are where we will likely spend most of our time so this is very helpful!

@GrantSmith 955 points in a month has got to be a Domo community record

You can hide the total number in chart properties as shown below: You can display the % values in chart properties as well as shown below: