GrantSmith Coach

@user045611 You can run it so the dataset will update the name (It's still the same dataset). After it's been run once you can then go back in and add the renamed dataset as your input and then change your output back to the correctly named version.

Hi @user007952 , You might be able to accomplish this using an ETL to calculate the national average since you can't do this as a beast mode as filters would affect the number. Take your data and calculate the average. Then adding a constant (Call it "join column" and set the value to 1) on both your calculated average…

Hi @Akhil Have you tried making sure your date field is all formatted as a date or a date with time (not mixing formats but a consistent format)? If you're only using the date and don't care about the time have you tried just formatting your data as a date? Another option might be to split out the date and times into two…

Hi @user08788 You can't use like and IN together. You'd need to split it out to separate logical checks. Try this: SUM(CASE WHEN (`Budget Segment` LIKE '%REL%' OR `Budget Segment` LIKE '%SMB%') AND `Advertising Line` = 'Non Working Dollars (NWD)' THEN `ApprovedAmountUSD`END)

Hi @user030892 , 1) You should try explicitly casting your date string '01-01-2019' as a date: cast('01-01-2019' as date) 2) Your data isn't getting grouped because you're not specifying an aggregate function for your fields. You need to select SUM, Average, Min, Max, Count etc for the fields you want to summarize and…

@jaeW_at_Onyx - That's how my data is formatted, it's utilizing the Type column to determine if it's either a projection or an actual number. I'm not tracking historical projections (it's forward looking only) so I'm not comparing old projections (It's simply just multiplying the YoY % over the last X weeks and then…

Hi @user06979 How I've done graphs like that in the past was to have two different lines plotted on the same graph and color code them differently while labeling one Actual and the other Forecast. To get around some odd graphing issues I had the actual stop at the current day (I was graphing on a by day granularity - you…

Hi @Whimzyy Assuming you're wanting the % based on all of your records and you just need the data summarized: SUM(CASE WHEN `Secondary Paid` > 0 then 1 ELSE 0 END) / SUM(1) This is assuming you don't have any groupings in your data (i.e. you only this % number only, once you add additional dimensions it will change for…

Anyone who has access to the dataset should be able to create an alert based on the dataset, anyone who has access to the card should have access to create an alert off the card. Sorry if I wasn't clear earlier. Here are some helpful knowledge base articles: Alerts + Data Sets:…

Anyone who has access to the card should be able to subscribe the the alert.

Hi @KJRowe6 If you have one incident per row then you don't need to have the MAX in your beast mode - It's always returning the highest date with your incidents. Try this: CASE WHEN DATEDIFF( CURDATE(), `created_at`) > 30 THEN 'Aged' ELSE 'Not Aged' end

Hi @user095063 How many input data sets do you have? Do you only have the one data set? Are you attempting to do a recursive appending data flow?

Hi @user022825 Domo currently can't handle sending alerts to a dynamic e-mail address. You'd likely need some external process (like a python script) to pull the data and send the emails based on the list.

Hi @user017636 You need to drag it from the data section not the data table section from either the dimensions or measures sub sections. Click on Data to display this section.

Hi @user046467 Short version: I used a python script interacting with the Google Ads API and then used the Domo API to upload a dataset. Long Version: I've had the same problems and ended up not using Google sheets entirely as the timing of the Google script to populate the Google sheets and the Domo job to pull in the…

@mynameisyannis - To follow up on @jaeW_at_Onyx 's dealing with UNIX_TIMESTAMP I've outlined usage and math to get days, hours, minutes and seconds in another post here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Date-Calculations-minutes-and-seconds/m-p/49259/highlight/true#M8465 

@jaeW_at_Onyx - Right, that's why I suggested to talk to the CSM to possibly having both the windowing function and the aggregate / windowing filters enabled. You are correct in that it might not have the expected results at times and is still sort of use at your own risk.

Using row limit, no, pfilters won't affect that setting. You might be able to use a windowing function to calculate the row number and then use a pfilter to filter the beast mode (this requires two feature switches on your instance, one for the windowing functions and another for filtering aggregates - talk with your CSM).…

@user055758 Are you wanting to remove the column from the table or reorder the columns? If you want to remove it from showing up in the table just click the X when you hover over the column in analyzer. If you want to reorder it you can click and drag the column around in the order of the other columns to reorder it. If…

Hi @user006513 Have you tried applying a row limit to your table to be 50? (Data Table > Row Limit - Just below the Add Calculated Field button on the column list)

@DP_DynamicData Facebook / Instagram recently redid some of their security / authentication with the API. They disabled their legacy API on June 29th, 2020. (See https://www.instagram.com/developer/). Likely Domo was using the old API and thus no longer works. You'll need to reach out to your CSM or Domo Support…

@Simon_King Assuming you're doing this in JavaScript you can utilize the getTime function: var ts = Math.round((new Date()).getTime() / 1000); The above example uses the current timestamp but you can swap out the new Date() call with a different date if necessary.

@nat040711, Have you tried just the denominator (second part) and see what that returns? Based on your formula I'm assuming you have another row in your table which has the overall total, is that correct? You could also attempt to do a windowed function (assuming you have them enabled in your instance - if not talk to your…

Hi @kacy If you have a contract start date and end date and you're looking at the dates in between you'll need to join your usage table to a date dimension table. Domo has a dataset of Dates (Cloud App > Domo Dimensions > calendar.csv). You can select the date from the date dimension table and left join it to your usage…

If you want to utilize PDP then yes. Those users would need to have a Domo license. The other, not as clean option would be to create separate filtered cards with the view you want users to have and then schedule the report to email an email address which shouldn't require them to have a license but will be very difficult…

Hi @user045611 Have you tried looking under the activity log (Admin > Activity log) and filtering the events there? I'm not sure if you're referring to user accounts or API accounts but start there.

@pprice11 CASE statements are your friend. CASEWHEN I8121="Total SS" THEN M8121*12WHEN I8121="Total PODZ" THEN M8121*12WHEN I8121="Total 5+1 " THEN M8121*2WHEN I8121="Total 3 Pack" THEN M8121*4WHEN I8121="Club Pack" THEN M8121*360END

Hi @user045611 If you only want users to have access to specific records within your data you'd want to look into PDP. This would allow the scheduled reports being sent to those people so they'd only have that information a part of the report. Again, this is assuming Jane should only be able to see Indiana data and John…

Hi @Steffi You might be interested in the Beast Mode Manager beta which would be an easier option for changing your beast modes in a single place rather than having to worry about using the CLI. Talk to your CSM to see if they can get that setup for you.

@JasonAltenburg I'll typically do a comparison to 364 (364 / 7 = 52) days ago so that the same days are compared against each other (Sunday - Sunday, Monday - Monday etc) which tends to get around this issue.