GrantSmith Coach

Hi @user017486 You could utilize a DataFlow to do the following: 1) Run a simple DataFlow to filter your records so only the last 30 days are included in the output dataset. 2) Change your dataset to only return the prior day and make it Replace for the update method. 3) Change the DataFlow from step 1 to append your…

Hi @user054938 Have you verified that the account used to connect Domo to Salesforce is the same one that has access to that account? Are the permissions for the new account the same as the old account? Your dataset isn't updating because you're having permissions issues, nothing to do with the schedule.

Hi @user078054 You'd need to format your data in such a way that it looks like this: CategoryYearAmountAerospace2018100000Aerospace2019110000Aerospace2020105000 Automotive201850000Automotive201960000Automotive202075000 You'd then need to use the Category as your x-axis, Amount as the Y-Axis and Year as the Series.

Hi @user020987 It'd be helpful if you provided a bit more context for your request. How are you stuck? What isn't working correctly? What is your expected output? What is your current output?

@MarkSnodgrass 's solution would work as well and likely be simpler. I have seen DATEDIFF not work correctly sometimes so I prefer the UNIX_TIMESTAMP method where it converts dates to a number in seconds and then doing some simple math: ROUND(( UNIX_TIMESTAMP(CURRENT_DATE) - UNIX_TIMESTAMP(MAX(`DaysAccessed`))/ 60 * 60 *…

Hey @CCCDomo Within an ETL you'd need to do a Group By tile to group based on the First, Last and Course names. Then for your resulting column select the Maximum aggregate. That will get you the last time it was accessed. You can then take that data output and pipe that into a Date Operations tile to calculate the number…

Hi @user065615 You'd likely need to contact Domo Support and see if they can restore the page from any possible backup they have as there isn't a way to restore it from the admin side.

Hi @user034162 Not directly on the card itself sadly. The way to do this is to utilize a webform and join that to a data fusion. If the user needs to change the parameters they'd change the values in the webform. Not ideal but the best solution we have at this time. @jaeW_at_Onyx has done a video which outlines this…

Hi @user020184 How are you wanting to fill down the values? Are you wanting to just use the same value? Increase the value? Are you working with a text, date or number column?

Hi @cjack-PML You'd need to do your grouping and aggregation within your ETL using a GROUP BY tile and creating two new fields (email 1 min and email 2 min). Then add both together using a calculator tile. If the new value is 2 then they both would exist and you can then use that new field to filter on in your cards.

Hi @cjack-PML You can't filter on aggregate functions (unless you have an alpha feature enabled to do so but doesn't always work as intended). What I'd recommend is using an ETL (or a DataView if you're in the beta) to calculate these numbers and then using the resulting dataset to graph where you can filter on the…

@VarunMB Currently no, Fusion / View + Web Form is the best option we have right now even though the usability is a bit lacking.

Hi @user084060 To my knowledge, that's the case for a regular bar chart as well.

It's because you don't have the week number in your comparison so anything that isn't 0 is treated as true. Try this: (CASE when MAX(MAX(`Fiscal Week`)) OVER () = `Fiscal Week` then (SUM(`Original Order Cases`)- SUM(`Cut`)) / SUM(`Original Order Cases`) end)

You could use a window function within a beast mode (talk with your CSM to get it turned on if you don't have it yet, it's a simple feature switch). SUM(SUM(`Numerator`)) OVER (PARTITION BY ...) / SUM(SUM(`Denominator`)) OVER (PARTITION BY ...)

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…