jaeW_at_Onyx Coach

careful @PhilD test thoroughly the behavior at the start and end of several years. your current implementation will lump days into the wrong year. YEAR(date) * 100 + weekyear(date) THIS IS CORRECT-er BUT UGLY. Concat( Year(DATE_SUB(`Date`, WEEKDAY(`Date`))), '/Period ', ROUND( WEEKOFYEAR(DATE_SUB(`Date`, WEEKDAY(`Date`)))…

post data and a screenshot that shows your settings. I'm pretty confident (without having tested ? that @GrantSmith 's window function should work if you sort by it.

i hope you solved your problem! ... If you followed the tutorial video Grant posted, (thanks @GrantSmith ) the solution should just be a matter of wrangling MySQL code ... this is a VERY google-able issue. But basically you just need to append a Current QTD and a previous QTD Period Type to the OFFSET_DATE table and then…

weird things can happen when you copy cards that contain beastmodes. keep in mind a beast mode saved to a card is only accessible in the card. if you have card 1 and it contains a beast mode called "test" saved to the CARD. then you create card 2 which contains a beast mode called "test" saved to the DATASET. THEN you tace…

Federated query should pretty much exclusively be considered if you cannot store data in Domo. FQ comes with major ... limitations including, - you can't transform data in Domo (b/c to transform data in domo you'd have to ultimately store it in Domo.) - your card performance is dependent on query execution in your database…

use a beastmode in your filter where you replace NULLS with a text value. ifnull(column, "No Value" )

window function. sum(amount) / sum(sum(amount)) https://www.youtube.com/watch?v=eifSYZIcPzg&t=868s

https://stackoverflow.com/questions/560709/levenshtein-distance-in-t-sql Levenshtein distance is a common way of calculating the similarity between two text values (i.e. how many characters would you have to change before they are the same. "cat > rat" = 1, "John > Jon" = 1. You'll have to rewrite it into MySQL but it can…

@Khan_Naziya calculating duplicates is easy? right, just date your domo governance dataset and count grouped by the beast mode... you might want to cast as UPPER and TRIM to do light data cleansing in case i have sum(Amount) instead of SUM(AMOUNT) ... re archive ... i guess that's an interesting feature but if i had to…

OOOPS!! ERROR -- sum activity on day 5 of the cohort sum(case when date_diff(activity_date, cohort_start_date) = 5 then number_active end)/ -- sum activity on day 0 of the cohort sum(sum(case when activity_date = cohort start_date_ then number_active)) over (partition by cohort_start_date) you may be able to do this…

is your % based on the number of people on day x vs number of people on day 0? if yes then use a lag function. create a beast mode, "day 5" -- sum activity on day 5 of the cohort sum(case when date_diff(current_date, cohort_start_date) = 5 then number_active end) / -- sum activity on day 0 of the cohort lag(sum(case when…

try creating a dataset view. you may need to have two. i don't understand whether you need number of days since a point in time, OR number of days since a value in a column. either way, you can structure this data if you take your transactional data and join it to a date dimension table. You can do that in a dataset view…

did you get the issue resolved? how many rows are your dataset and are you using COUNT DISTINCT? ? if you filter to less data or simpler beast modes, does it work?

you don't necessarily have to hardcode the ratios into the data. In fact. Don't do that, it makes it so your card doesn't respond to filters. instead use nested case statements instead of .. concat( case when round(SUM(`This Year` - `Last Year`) / SUM(`Last Year`) * 100, 0) > 0 then '<div><span style="color: green">' ...…

https://knowledge.domo.com/Connect/Personalized_Data_Permissions_(PDP)/PDP_Policy_Autocreation i use this tool for generating pdp policies.

... in excel you're defining a calculation for period over period column... even though you don't call it a beast mode, you ARE defining a formula... BUT that said, the Sparkline chart does give you that ability. If you must do it in a table card you'll have to build a beast mode.

sorry if i'm not understanding. is the data actually uploaded into Domo that you want to see? (i.e. that has a start date outside of the range of data visible in the card)? if so, then ... can you just remove a date filter?

maybe try uploading a subset of the data? do you have clean key-value pairs, or do your values occasionally contain arrays? 

as @GrantSmith said, try Workbench. If Azure DW supports an ODBC driver you should be able to round trip the data from Azure, through your Client machine into Domo via WB. It's not ideal, but it gets the job done and it supports UPSERT. That said, contact your AE / CSM, Azure DW seems pretty common and it may already be on…

a <br> tag is just a line break. so ... recreate the beast mode without the line break.

a fusion on that many rows will work fine. We've used this solution on billion-row datasets. It looks like your data has a lot of dimensional columns already. Using a date dimension, you could compress the width of your fact table and build a framework that introduces a degree of flexibility with 65 columns of low…

make a beast mode without the formatting, and export that to your crm.

Super easy! Just UNION the data onto itself. And then replace the rep's name in the second copy with "all reps" then use a Window Function in Analyzer sum(score) / sum(sum(case when rep = 'all reps' then score end )) over ()

Do you want to rename columns or do you want to rename the VALUES in the column? I think @GrantSmith is describing renaming columns and what you actually want to do is remap values. If you're after the later, You can build a beast mode with a CASE statement CASE when `Company Name` = CompanyLongName' then 'A' when `Company…

You can use the Excel Addin https://app.domo.com/labs/domooffice/admin/domoadminsetup.msi to perform many bulk administration tasks.

What's your use case? I assume it's something along the lines of, you want two owners so that if one of them is on holiday or leaves the company, or a dataflow falls over, multiple people can administer the data pipeline. Best practices would be to set up a service account DomoBI@Your_company.com and then set up an email…

https://www.youtube.com/watch?v=J1yU6PAGXc8 use DatasetSchema and CardsFields&Beast Modes 

Glad you found something that works. I have covered window functions so many times on my YouTube channel! https://www.youtube.com/watch?v=eifSYZIcPzg&t=2247s https://www.youtube.com/watch?v=39VHAQEYHAc&t=316s

@user092697 ask your CSM about the Filter Views beta.

uh... is this not what you're describing for?