GrantSmith Coach

Hi @Yogesh How did your regular expressions not work? Is there some anonymized data you can share? Have you played around with a regular expression editor like https://regex101.com/ ? Can you post a screen shot of your tile with the regular expressions in it?

Hi @Khan_Naziya Simply Federated Queries has Domo pull data from your local databases rather than having the extra step of ingesting the data into Domo's data ware house and then having domo pull from the Domo warehouse. It allows you to have up to date data rather than relying on the ingestion process continually being…

Hi @user19019 There's several examples of doing period over period charts on the dojo. I'd recommend you configure an offset dimensions table to join your data together. @jaeW_at_Onyx has done a great video outlining this process here: https://www.youtube.com/watch?v=CDKNOmKClms I've given a more textual write up on this…

Thinking about this some more, it's likely because Domo is treating your two series data points as separate rather than treating it as a single total over the sales person. You could utilize a window function to get the sum for each salesperson irregardless of the product type. SUM(SUM(`sales_amount`)) OVER (PARTITION BY…

Hi @user084060 Could you post some anonymized examples of your chart to give a better understanding of what you're seeing compared to what you're expecting? Is my understanding correct in that you have the sales person on the x-axis and the sales amount on the y-axis with the type of product as your series?

Having a pay period date dimension is the most flexible option and probably the best one that I'd recommend. Theoretically you may be able to calculate which pay period it is using a beast mode and the WEEKYEAR() function and dividing by 2. You may need a week offset depending on how / when your actual pay period falls.…

It's standard cron type scheduling. There's a lot of resources online but one I like to use is https://crontab.guru/ which helps decode cron strings. https://en.wikipedia.org/wiki/Cron is another good resource to understanding the special syntax. The one exception to this is I believe Domo includes the seconds as the first…

Here's a link to the knowledge base article outlining Dataset via Email connector: https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieval/DataSet_via_Email_Connector This will help explain that connector and how to effectively utilize it.

Hi @user082291 From what I'm understanding you're asking about renaming the column / field name and not the values in the field itself? You can do this several ways, the first is when editing a card you can select the field displayed in the x-axis/y-axis/series etc section on top of the graph and put a value into the Data…

Hi @user054938 Your use case is a little unclear. Are you wanting the same date for every single row in your dataset or are you taking snapshots of your data and want the date when that snapshot occurred? If you're just looking for the same current date value for all the rows you have two options. The first being a Magic…

Hi @boston_mcclary Yes, when you configure the Email dataset connector it will generate a unique email you can use to send emails to (there's a handy button to copy the e-mail address to your clipboard once it's created). CSV or Excel files are supported and there's several configuration options which you can configure to…

Hi @user054938 You'll want to look into a recursive/snapshot dataflow where you can add the current timestamp when the dataflow runs and then append it to your output dataset. The benefit of this is that you can make sure no duplicate records are included in your output dataset and you can limit your dataset to a specific…

Hi @user046467 This is because your CASE statements have no ELSE clause causing them to return NULL. When SUM comes across NULL it treats the entire value as NULL. To correct this you'd need to make sure your CASE statements return a value. In this case since you're adding values together with SUM you can add 'ELSE 0' to…

@jaeW_at_Onyx with the simpler option. I'd recommend his solution.

If you're using ETL 2.0 the recursive portion will be a bit different since it handles NULLs differently than ETL 1.0. The Magic ETL 2.0 documentation can be found here: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_DataFlow_in_Magic_ETL_v2_(Beta) 

Hi @user046467 You'll want to look into a recursive dataflow where you can add the current timestamp when the dataflow runs (on Google Sheet update) and then append it to your output dataset. ETL 2.0:…

Hi @curious Does your sub instance have a separate URL or is it all contained within your main instance URL? If it has it's own URL have you tried using that URL instead of the main instance URL?

Hi @user033862 Depending on how granular you'd like the snapshots and the number of employee records this could end up being a lot of records. What I'd recommend is having a dataflow run every so often (probably monthly unless you need it more granular) where it could calculate the number of employees, hires, terminations…

Hi @AJ2020 Are you including `Company Name` in your graph at all?

Hi @curious I can't speak to the road map but if you're using APIs which haven't been publicly exposed you'd need to be careful because they could change at anytime without warning. I wouldn't rely on them if possible because the uncertainty of changes.

Hi @user012140 The box and whisker plot doesn't necessarily plot the min and max of your data but rather plots the 25th, 50th (median) and 75th quartiles. The whiskers are equal to 1.5 * the Interquartile Range (IQR) on either side. The IQR is the 75th quartile - 25th quartile (the size of the box). When displaying all of…

For testing, since you said it works with a where clause have you tried replacing your WHERE clause with WHERE 1=1 to return all the records? 

Hi @user053667 Since you're wanting to pull all of the data in a dataset - instead of using the query have you attempted to just export the dataset itself using the api? https://api.domo.com/v1/datasets/{DATASET_ID}/data?includeHeader=true&fileName=output.csv This would export your dataset to the output.csv file. You…

So for last week, what were the calendar and fiscal months you were expecting? 10 and 11 respectively? With the image you posted are you suggesting that the two numbers should line up? How are you grouping your data? Which columns represents the hard coded formula and which represents the new formula?

Hi @Crisocir You can utilize a windowing function to calculate the rolling maximum. MAX(MAX(`JDL Count`)) OVER(ORDER BY `Batch Date`) Window functions in analyzer require a feature switch. Talk to your CSM if you don't already have them enabled in your instance. 

Are you able to filter on another date field which isn't a beast mode? Can you try and calculate that date in a dataflow first and then do the filtering so it's not relying on the beast mode?

Hi @user006467 You can create a group in the Admin section (or have your admin do it if you lack permissions). You can then send a scheduled report to that specific group of Domo users.

Yes, there isn't a limitation on the number of records a CSV can store or that would be exported from the API to my knowledge. You'll just have a very large file.

Hi @user094816 You can't directly export the data in chunks from the Domo API, only the entire dataset. There are some sample Python files they provide to show how to accomplish this: https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py shows how to connect to Domo and export a dataset. I'd recommend…

Hi @user041053 I don't think there's a Q&A or Guidelines for the training courses however Domo does offer some Certification Prep courses to help you prepare for the certifications. You can find the Domo Professional Certification Prep courses here: https://learndomo.domo.com/learn/lp/7/domo-professional-cert-prep For…