GrantSmith Coach

Hi @eric_tetik You'd want to reach out to Domo support as it's an issue behind the scenes on their end and they'd be able to get you a better understanding of what the issue is since they have access to those logs.

@walker_page My understanding is that they should be based on the company timezone settings of your domo instance (defined under the admin section)

Hi @mberkeley Page filters apply to all cards on the page so you can't selectively apply the filter. What you could do is utilize some filter cards (one for customer, one for industry) and chance the card interactions for each filter so it only applies to your cards individually. You might still have users using the page…

Hi John (@Jobur ) Jupyter workspace is all self contained within the Domo environment. You don't need to have anything installed locally. If you want to do your analysis locally you could get python / jupyter installed on your local machine and then utilize the pydomo package to pull data from Domo as well. Domo cards are…

Hi @HowDoIDomo Do you have some sample / anonymized data you could post to get an understanding of your data format?

+1 for the APIs. They are great for automating some tasks like this. Personally, I've used the PyDomo package and a python script to interface with the Domo API to update the user attributes.

Hi @walker_page These are unix timestamps. Typically they are jut a simple numerical representation of the seconds since Jan 1st, 1970 however in this case these are unix timestamps in milliseconds instead of seconds (just divid the number by 1000 to get the number of seconds). Language have tools to convert these easily…

@cthtcc The rows are greyed out because domo has archived off those executions so you can't restore from those versions.

Hi @gbennett You could utilize a Magic ETL dataflow and a Replace Text tile in combination with a regular expression. It will keep the original value if it doesn't find a valid email address. Here's a regular expression which will find an email within a string. (\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}\b) You can copy and…

Apologies, I had MySQL on the brain but mean to state Magic ETL 2.0.

Hi @user025461 This is because MySQL 5.6 (version Domo is built off of) doesn't support column names longer than 64 characters. You have a few options to work around this issue. 1) Use a Dataset view (or a magic ETL) to rename your column to something less than 64 characters and then use that dataset inside your MySQL…

Hi @user06209 You can utilize window functions in a beast mode (you just need to have them enabled - talk to your CSM) SUM(SUM(`Amount`)) OVER (PARTITION BY YEAR(`Date`) ORDER BY `Date`)

@HowDoIDomo That code is for a MySQL dataflow which will generate the date dimension table for you but it's built off of the Domo Date Dimension table. You can find the Domo Dimensions connector in the Cloud App lists for data connectors. Then select the dates dimension and give it a name. In my case I called it Calendar…

Hi @user048760 What you're looking for is the CONCAT function. It allows you to add multiple columns together with constants to create a single value. If you're looking for just the URL (which you won't be able to click on but would only be displayed) CONCAT('https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`)…

Google: CASE WHEN `marketing_source_c` = 'Google' THEN `Date_entered` END Google Paid: CASE WHEN `marketing_source_c` = 'Google Paid' THEN `Date_entered` END SPS_Website: CASE WHEN `marketing_source_c` = 'SPS_Website' THEN `Date_entered` END Essentially you'd have those three case statements in 3 separate beast modes when…

I misread you answer. Thanks for the clarification @ST_-Superman-_

Hi @taylordomo Do you have any extra code / context for how you're calling ds_query? Are you passing your dictionary as the query or just the query string? Looking at the code for the query function it looks like it does the packaging automatically for you so you shouldn't need to pass in {"sql": "select * from table"} but…

Hi @user06209 The Data Governance datasets would get you the data you're looking for and allow you to easily visualize / analyze the data. In addition it'll allow you to automatically keep it up to date (and is platform independent). As @ST_-Superman-_ mentioned you can utilize the Excel plugin but that's only supported in…

@Kumar619 That's because you only have a single year being displayed. Are you wanting only the prior year to be displayed or multiple years?

Hi @Kumar619 Simple way is to utilize a Period over Period type chart to plot to Year over Year change percentage along with your values. In the date selector you can compare to a previous time by telling it how far back you want to compare to and in what unit.

Hi @msharma The filter is applied before any beast mode is calculated so if the card is filtered for Jan&Feb 2021 you won't have access to the 2020 data points. If you need that data point then you'd likely need to calculate it in a dataflow before hand. As for your G_L_ACCOUNT No_ field - you have different values for the…

You wouldn't be able to do that on the card because the filter happens before any beast mode is applied. You'd need to aggregate your data in an ETL before hand.

Hi @richardjmarshall You've got two options. 1) You could use a beast mode to determine if a date is from 2 months ago CASE WHEN LAST_DAY(CURDATE() - INTERVAL '2' MONTH) = LAST_DAY(`Date Field`) THEN 1 ELSE 0 END and then just filter on that value being 1. This method you're always stuck looking at 2 months ago according…

Hi @user03634 Sadly the label position is fairly limited currently with domo. You can only place all of the labels in the same relative position so you'll always have your overlap. The only option you have is to leave the overlap as is or uncheck the "Allow Overlap" option on your settings and not have some data labels…

Hi @user030156 / Michael I'd recommend using a dataset view (talk to your CSM to join the beta if you don't already have it) to calculate the date and hour of your timestamp. Date: DATE(`Timestamp`) Hour: HOUR(`Timestamp`) Then group based on these two fields (date and hour) and count the number of tickets you have using…

Hi @kacy There isn't a simple way to do this. You can conditionally set the color or a cell / row in a table using the color rules settings however it's only for that columns itself. You can't conditionally configure the color of one cell based on another column. You might be able to utilize an HTML table and do some…

Hi @msharma since you’re wanting to do a conditional sum you need to use a case statement inside your sum to only select the values you want sum(sum(case when `Transaction` = 1 then `Amount` else 0 end)) over (partition by year(`Posting Date`)) Repeat for transaction 0

Hi @akshayaviswanathan Simple answer - @Sam1 is correct... no. There is no bulk update technical And complex answer: Utilize the Java CLI to export your card definitions as JSON (backup-card command). Write a script to clean these files to remove the filter from the JSON definition Restore the cards from the updated JSON…

Hi @Kumar619 on your data table in analyzer there is a text box you can enter a number which will restrict the number or records displayed. You can sort by your metric and it will then display the top X number of records

Hi @Slapo Have you tried viewing your data as a table in analyzer and applying filters to see if your rows still show up? What happens when you lift some of your filters?