GrantSmith Coach

Hi @user025699 Short Answer: You need to reformat your data so you have one record per month instead of a start + end record. Beast modes can't create new records (which is what you'd need to do if you want to count 50 for each of those months). You'd need to restructure your data with a dataflow and break out the monthly…

Hi @user027693 The Domo Java CLI (https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool) tool has the search-replace-bm command you can try and utilize to more programatically change beast mode definitions. > help search-replace-bmsearch-replace-bm: Perform a search and replace…

To confirm this do not select to graph by day but remove your date from your table chart and your summary number as well as the number in your chart table should be the same

Hi @user054934 Likely this is because your data is being partitioned by day in your graph but being calculated across your entire data set for your summary number. So if you had a unique ID for multiple days on your summary number it would be counted once under your distinct summary count but would appear in multiple days…

Hi @adrianiy Have you downloaded & configured the Domo Java CLI tool? https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool

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 ...)