Best Of
Re: Syntax of ANOVAF(), ANOVAP() and TTEST()
Not sure if you have already seen this here: https://domohelp.domo.com/hc/en-us/articles/360044289573-Supported-Functions-in-the-New-Magic-ETL
Function Name
Description
Example
ANOVAF
Returns the F-value of a one-way Analysis of Variance of the samples. At least two samples must be provided, and each sample must have at least two non-null values. Note that a one-way ANOVA on two samples is equivalent to the Student's t-test (see the TTEST function).
See also: ANOVAP()
ANOVAF(sample1,sample2[,sample3[,...,sampleN]])
ANOVAP
Returns the p-value of a one-way Analysis of Variance of the samples. At least two samples must be provided, and each sample must have at least two non-null values. Note that a one-way ANOVA on two samples is equivalent to the Student's t-test (see the TTEST function).
See also: ANOVAF()
ANOVAP(sample1,sample2[,sample3[,...,sampleN]])
TTEST
Returns the p-value result of a Student's t-test. Arguments sample1 and sample2 are two numeric columns with at least 2 non-null values each. The tails argument is either 1 or 2, indicating a one- or two-tailed test. The type argument is a number 1 through 3. Type 1 is a paired sample test; for this type of test, values in both sample1 and sample2 must be non-null or be ignored. Type 2 is for two samples with the assumption of equal variance. Type 3 is for two samples without the assumption of equal variance.
TTEST(sample1,sample2,tails,type)
These were under Statistical Functions
Re: Layer multiple filter views on dashboard?
Hi @RSViju
How is your data structured? The filter cards on your dashboard should apply both filters to your dataset.
Re: Syntax of ANOVAF(), ANOVAP() and TTEST()
Update: I figured it out.. looks like in magic , the function needs to be added within the Group by tile add formula providing at least 2 fields containing the samples to analyze
Godiepi
Re: Generate Date Range Column from Two Date Columns
I just posted something for a similar question but you can use the calendar.csv dataset from the Domo Dimensions connector.
Then you can use MySQL to get your desired output (MagicETL doesn't support conditional joins like this directly. You'd have to do a cartesian join [add constant column to both - say a value of 1 - and then join both datasets on that value then use a filter tile to filter your dataset down. This would exponentially increase the amount of records MagicETL would have to process and isn't as straight forward as MySQL in this case)
select `Id`, `dt` as date, `field1` FROM `calendar_dates` as cd JOIN `my_dataset` ds on cd.dt BETWEEN ds.`start_date` and ds.`end_date` and cd.d = 1
cd.d=1 just tells it to return the record for the first day of the month since you're wanting to do it on a monthly basis and your data appears to use the first day to represent each month.
Re: Is there a way to auto-delete the data after a certain period of time?
Hi @yli_2596, I am assuming you are referring to the data in the underlying architecture, and for that, there's currently not an easy way to delete data. A few options you can explore are:
- Creating a dataflow to input your dataset, filter out the rows you don't want and then write it out to another dataset,
- Temporarily using the replace method and then go back to your append method (using the ETL tiles),
- Requesting certain rows to be deleted via Domo Support
amehdad
2021 Community Award Winners
Domo’s been celebrating top community contributors for the past several years – and this year’s recipients were undoubtedly some of the best. With the COVID-19 pandemic cancelling our ceremony for the past couple years, these contributors were well-overdue for some recognition.
We’re pleased to share the following individuals who have received awards for outstanding Domo community achievements (in no particular order):
Grant Smith (@GrantSmith): Dojo Black Belt
Sweetwater
Grant is the first ever black belt since we relaunched the Dojo in 2021. Climbing to the black belt rank is no small feat. In addition to helping people solve difficult questions in the Dojo, Grant is actively involved in Domo’s beta program and has spoken at many events. Thanks, Grant!
Aquib Mehdad (@amehdad): Dojo Rising Star
Deloitte
Aquib is an impressively fast rising star on our community forums. As a newer member of the community, he has climbed 6 belts on the Dojo in the past year. In addition, Aquib had the two most popular ideas in a recent community identity poll. Thanks, Aquib!
Mark Snodgrass (@MarkSnodgrass): Top Product Idea
NLC Mutual Insurance
Mark submitted the top product idea in 2021 –which was “Status of Ideas in the Ideas Exchange” with 14 upvotes. Not only does Mark frequently submit great ideas, he’s the second all-time leader on the Dojo, leads the most active private company board, and had multiple entries in the #isolveditindomo Competition. Thanks, Mark!
Ashleigh Stevenson (@Ashleigh): Allstar Advocate
CAE USA
Ashleigh is one of the most engaged members of the Dojo and is always advocating for the Domo product. In 2021, Ashleigh helped put together a Domo + CAE USA customer success story, completed multiple surveys, left online reviews, and continually engaged and supported Domo. We appreciate Ashleigh’s willingness to share her knowledge and Domo success story with others. Thanks, Ashleigh!
Scott Wagner (@swagner): Allstar Advocate
Mayer Electric
Scott has gone above and beyond to share his love for Domo and his success story. Scott participated in analyst interviews, left online reviews, took surveys, helped with blog posts, and even spoke during a Domo webinar. We appreciate his continual engagement and support of Domo. Thanks, Scott!
Michelle Hamad: Top Content Producer
RWI Logistics
Michelle was one of the top submissions in the #ISolvedItInDomo competition. She outlined a unique solution to a geographic data problem. Be on the lookout for when her article is posted on Domo.com. Thanks, Michelle!
Garett Hansen (@garetthansen): Top Content Producer
MX
Garett was one of the top submissions in the #ISolvedItInDomo competition. He wrote a very concise solution that has broad applicability for anyone looking to keep track of changes to a data set. We’re excited to share your article with the community on Domo.com. Thanks, Garett!
Beau Detcher (@bdetcher) & Stephanie Butterbrodt (@StephanieB): Beta Allstar
EJ
Both Beta allstars come from the same company. Chuck Irwin, leader of the Beta program here at Domo, was especially impressed by Beau and Stephanie’s consistency and great feedback. Thanks, Beau and Stephanie!
Bryan Van Kampen (@trafalger): Community Builder
BT Partners
Bryan well-deserves the community builder award for his service in running the weekly Domo power user group and engagement on the Dojo. The power user group was originally started by a Domo employee, but since Covid, Bryan picked up the baton and has been carrying it ever since. Thanks, Bryan!
Kyle MacNamara: Community Builder
Graphable
Kyle has been a pioneer with Domo. This past year he volunteered to write the first article on our new customer content community blog on Domo.com. He has been involved with Domo since the early days and continues to drive thought leadership in the community. Thanks, Kyle!
Jae Wilson (@jaeW_at_Onyx): Community Builder
Sony Playstation
Jae has been a crucial member of our community for years. In 2021, He organized and ran an EMEA community user group conference that was a huge success. He also creates valuable content and answers questions in the community to help everyone up-level their Domo skills. Thanks, Jae!
Congratulations to our 2022 Community award winners! Thank you for all you’ve done sharing your Domo knowledge with fellow users. We’re excited to continue to grow the community program and recognize more community members next year.
SHOW THESE WINNERS SOME LOVE IN THE COMMENTS 👏
Anna Yardley & Richard Carey
Domo Community Team
Re: Beastmode Cleanup
It depends if you're deleting a beast mode that's saved to the dataset or not. If you delete one from the card that isn't saved to the dataset then it's just that card.
There isn't a simple way through the UI to get the duplicated beast modes however you can utilize the DomoStats / Data Governance datasets to get the cards and beast modes datasets which should have the beast mode definition and if it's saved to the dataset. You can then pull the powering dataset from the card dataset, group by the dataset and see how many records where the name and formula are the same and if there's more than one record you have a duplicated beast mode.
Beast Mode Manager will archive off the beast mode and remove it from view. This is better if you want to be able to potentially recover the beastmode at a later time.
Re: Replacing single quote/apostrophe with nothing
@tejusarora Thanks! I tried that earlier and it was giving me an error, but now it is working as well.
Re: Replacing single quote/apostrophe with nothing
Hi Mark,
SQL uses two single quotes to represent one in a string. so try using
REPLACE(`Longitude`,'''','')
This should definitely work
Re: Replacing single quote/apostrophe with nothing
ETL Formula tile doesn't seem to want to handle single quotes correctly. I've been able to get it to remove single quotes using the Replace Text tile but you may have to put in the single quote a couple times as I've had it remove the single quote and replace my single quote with empty string.
You can copy the JSON code below and paste it into your ETL which should remove the single quotes. You'll just need to update the field names.
{"contentType":"domo/dataflow-actions","data":[{"name":"Replace Text","id":"5a02f438-db47-4f1d-ac57-484a94fcf775","type":"ReplaceString","gui":{"x":156,"y":180},"dependsOn":["0c670718-8546-4cc5-a42b-51e326b70b6c"],"removeByDefault":false,"notes":[],"fields":[{"inStreamName":"Promotion","useRegex":false,"replaceString":"'","replaceByString":"","wholeWord":false,"caseSensitive":false}]}]}