GrantSmith Coach

Hi @smitiyadav Is it a matter of the time and data are the same but Domo is just pulling data in 5 hours behind or is it the data appears the same but the times are different? If it's the former it may be because of a delay from the API. If it's the latter it's likely a timezone / UTC issues. Domo expects data to be…

Hi @ravimohan911 Currently I don't believe this is possible. Default page filters are still in Beta and aren't integrated with Domo Embed at this time. That would be good feedback for the beta team though for this specific use case.

Hi @Joe_M Sadly that isn't an option at this point to replace the total number with a hover text value. It will only show the hover text where the mouse is. It's a great idea and I suggest adding it to the Domo Ideas Exchange: https://dojo.domo.com/categories/ideas

Hi @danidiaz Segments are a beta feature right now which allow you to define groups in your dataset based upon certain criteria. "Segments allow you to quickly perform market share analysis and measure one group of data against another. With Segments, you can examine different subsections of your data while still having a…

Your version is close you just need to specify your units (day intervals): select * from `table` where `date` > CURDATE() - INTERVAL 7 DAY DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) and CURDATE() - INTERVAL 7 DAY are functionally the same. Also CURDATE and CURRENT_DATE are the same, they just have different names.

Hi @Jessica , Currently this option isn't available but it'd be a great post for the Idea Exchange: https://dojo.domo.com/categories/ideas

I don’t think the email download would work in this case as it can’t find the link on the page. Are there other ways to get the data? Do they have an API?

Domo documentation is lacking in this aspect. I'd recommend you get in touch with your CSM to see if they can assist or get their development team to help.

Whomever is logged into the workbench server first gets the updates, any other users don't but will see the message you're seeing. You'd need to kill the other workbench processes owned by the other users (either by asking the other users or killing it in Task Manager) and then restart your workbench program to then get…

Hi @MikeMiller, Are you utilizing Single Sign-On (SSO) for your authentication or are you doing Direct Sign-On?

Hi @PatM Is your underlying data a numerical value or does it have US$ in front of the values (not displayed on the card but in the raw data)? Is it only in the Summary Number or is it in a table card as well?

Hi @OllieSouthgateAKA In the actual URL in your email (not the clickable link text) - does that have either report or download in the link? When you go to that new page - Does the actual hyperlink on that page link to an actual XLSX file or is it some other type of link? Does that link on the page have either "report" or…

Domo expects data to be imported as UTC. Is it possible to import your data using UTC instead of the local time?

+1

@rahul93 Not currently as it thinks it's already an aggregate.

@KelvinoY You'd utilize a Dataset View (Beta) or a DataFlow to join the two datasets together. There's a DataSet ID you can utilize in the governance datasets to filter for your specific one. It's a 32 digit hexidecimal (letters and numbers) value. You can get it from the URL when viewing the dataset in Domo.

Hi @nicangelica What you're looking to do isn't quite possible since you'd need to do a window function inside a window function to determine if that record is duplicated or not within your dataset. @rahul93 The card will fail to load if you're using any other aggregation on the other datasets. While that is correct SQL…

You'd need to pivot your data yourself then outside of a pivot table card (using a dataflow or other mechanism) and utilize a standard table card with your pivoted data

Hi @user074136 Domo doesn't allow for different data types in the same column. To get around this you can utilize a beast mode to customize the formatting of each row manually with several CASE statements: CASE WHEN `row name` = 'Gross Retail Revenue` THEN CONCAT('$', ROUND(`value`, 2)) WHEN `row name` = '% Retail…

Thanks for the workaround @Jaketh13 !

@jaeW_at_Onyx if a customer only purchases product 1 then they'd appear in the count which isn't desired. @user046467 The easiest option would be to utilize an ETL to filter your dataset twice (one for each product) then inner join back together based on email address from your product 1 and product 2 filter outputs and…

Have you tried passing in the id of your custom role instead of the string name?

Hi @faisalnjit I've utilized a browser plugin to refresh the page on a scheduled time for some dashboards I've configured. Alternatively you might be able to utilize a publication to do a slideshow of separate cards and cycle through them on a timer (this doesn't support pages currently though).

@user046467 How are you displaying your information? Are you wanting to just show a list of customer? What if someone buys product 1 twice and product 2 twice? Do they count as 1 or 2 in that case?

Hi @b_rad Are you wanting just the single point displayed or that value for all of your dates? If you want it for all of your dates you could utilize a window function to calculate the maximum value. MAX(SUM(`value`)) OVER ()

Hi @user018766 Currently no, you can't conditionally filter a dataset based on values from another dataset with different column names.

Hi @Rvannoy You can utilize a beast mode to calculate different buckets to then allow a checkbox selector to utilize. If you're looking for date manipulation I did a writeup and video of this a while back for the IDEAs conference. You can refer to…

@swagner Since beast modes don't support regular expressions you'll need to do it within an ETL. The JSON code I posted above will give you the starting point for a Replace Text tile in a Magic ETL 2.0 dataflow. You can copy that second code block and then just paste it when in the ETL it'll put that tile in for you with…

Hi @swagner Alternatively you can utilize a regular expression in a Magic ETL Replace Text tile (not exactly what you asked for but wanted to share just in case you wanted to go this route): ^.*-([^-]+)$ This will handle any number of dashes in your string. Copy and paste this into your Magic ETL:…

Hi @AnwarBham Short answer is no, there isn't something to easily determine the lineage of a field. There is the dataset lineage tool on the dataset which will show you where the overall dataset is used but nothing specific to a field. The closest you could get is possibly using the governance dataset "Dataset Schemas with…