GrantSmith Coach

Hi @user063446 The key functionality of Domo drill paths is to dig deeper into the data you had selected from the parent card. To do this Domo needs to filter your underlying dataset. If you're wanting to have the user go to a different card without filtering you could have the card on a dashboard and change the card…

Hi @user022825 Currently you can't exactly do conditional joins with Magic ETL. You'd need to create a single (or multiple) columns you can join on and then do your filtering / conditional join logic after the join has been done. Simply put there isn't an easy way of doing this type of join with Magic ETL. There are…

Hi @mhouston Unfortunately it appears that their API only supports pulling an individual file and not an entire directory. If you're wanting to programmatically pull all files in the directory you options would likely be either write a script to query all of the files in the folder then call the API individually for each…

Hi @user075511 I had too many issues going down the Google Sheets path with timing issues and the data not being updated in time when Domo would attempt to run the script or the Google Sheet population script would fail silently and I had no visibility into it until it was already too late and in the system duplicating…

Hi @JaredUJZ When you created the API secret and key were you logged into your account that you're wanting to pull data down to? Do you have the Data API enabled for that API project in google's platform? If you import the Data API -> Channels report into Domo are you getting the correct channel information you're…

Hi @user075511 With my interactions with the many different APIs Facebook has been... not great. They don't support service accounts and require a specific personal user to access their API. The only way I know to get around it would be to create a bogus personal account which appears to be a real person but is solely used…

Hi @user034162 It sounds like you want the rankings within each col1 subgroup if I'm reading your post correctly. You should be able to get rankings unique to each subgroup instead of the entire dataset by adding col1 to your PARTITION clause RANK() OVER (PARITION BY `col1`, `col2` ORDER BY SUM(`amount`))

Hi @user020987 Was your code copied directly from your beast mode or did you type it here manually? It appears you're using single-quotes for your field name instead of back ticks which when comparing the two strings (instead of the column value and a string) will never match so EAST is always returned. Try this: CASE…

Hi @user017486 I posted an answer to your question here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-to-delete-rows-automatically-based-on-a-date-in-a-dataset/m-p/51468/highlight/true#M9105 

Hi @user017486 I posted an answer to your question here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-to-delete-rows-automatically-based-on-a-date-in-a-dataset/m-p/51468/highlight/true#M9105 Next time you should only need to post your question in a single topic area as they're all well monitored.

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.