GrantSmith Coach

Hi @user007486 Have you tried adding in your series but then setting your data label setting to be the Percent of Category (%_PERCENT_OF_CATEGORY ) instead of the series?

Also, to clarify Window functions are a feature switch. If you don't have them enabled in your instance talk with your CSM to get them turned on.

Assuming you only have a single year's financial data in your dataset (not spanning years) you could try a window function which would get you the highest week number across your entire dataset: ``` MAX(MAX(`Fiscal Calendar Week`)) OVER () ``` instead of ``` MAX(`Fiscal Calendar Week`) ```

Hi @user060355 Your data has two different time slice units (daily - sales and multiple days-consultations) which makes filtering your data difficult. What I'd recommend you do is reformat your data so that your sales and consultations are both sliced by day. This would allow you to easily join and slice your data on any…

Hi @user05215 Because how Facebook designed their API this isn't an option. It's only designed to pull data which starts in your date range.

The other test you can do is test the final 1/4 in a separate file to confirm is a size issue and not a record formatting issue in the file.

Hi @user14700 Have you tried downloading your file manually and then using an online JSON parser to see if there's a formatting issue with your file?

Hi Jason / @user007486 You're not able to nest cards inside of cards however how I've done it in the past is to utilize some beast modes and some unicode characters like the following (this is calculating YOY % - you can adapt as necessary): ``` concat( case when round(SUM(`This Year` - `Last Year`) / SUM(`Last Year`) *…

Hi @user084060 You can't remove hover text currently. Your best bet would be to put a single period in the hover text setting however it will still show. You could also customize the hover text to give your users more relevant information (click the + to see predefined values) rather than having an empty hover text.

Hi @Yogesh How are you defining similarity? Spelled the same? Sound the same?

Hi @VarunMB You can attempt to write a custom connector if you're savvy enough. Domo has some fairly good documentation on the process here: https://developer.domo.com/docs/custom-connectors/connector-dev-studio 

Hi @mcgeete Bi-weekly isn't an option to send a scheduled report currently. Only daily, weekly, monthly. To my knowledge there isn't really a good way to easily schedule the report to be sent bi-weekly.

Hi @user057041 UPSERT isn't available for many connectors currently. Only Workbench and those connectors listed https://knowledge.domo.com/Connect/Managing_DataSets/DataSet_Update_Methods#Upsert_and_partition have the ability to do UPSERTs. Right now it doesn't appear possible to do UPSERTs with the Azure SQL DW Connector.

Hi @user033540 You could utilize a calculated field transform on your workbench job to attempt to parse out the characters from your filename field to leave only the formatted date. Another option is to leave it as is and use a view (Beta) or Data Flow to calculate it after it's been ingested into domo and use this new…

Hi @JustinB If you're using a web browser you can right click and select "View Page Source" or something similar to view the actual HTML used to display the image. You'd need to look for the <IMG src="xxx"> tag to determine the format that flashtalking is using and how they're using the same identifier as the link to them…

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)