jaeW_at_Onyx Coach

:P when asking a question in Dojo,a lot of times a proper samle dataset and plain english description of what you're doing helps! Good luck. Just keep in the back of your mind, if you want the % of total per month you just have to partition by year / month.

I laughed. Because, this video is already on YouTube. https://www.youtube.com/watch?v=Esnu1PSxRjM&t=26s

user046467 in my initial comment i indicated you have to create the column "month" on the dataset (not a beast mode). in a similar way, you should put Month on the axis instead of using Date. if you need yearMonth, create the column yearMonth. Alternatively, remove date from the axis and try adding it again. Domo's UI can…

you are constructing a URL. I'm not sure this is the solution, but you know how spaces in URLs get converted into %20. I imagine + is a reserved character, so you have to find the equivalent for the symobl. Or google 'escape character url' i don't know if that's a thing.

Do you have custom roles enabled? Talk to your CSM.

Domo Magic ETL scripting tiles. https://www.youtube.com/watch?v=lhj9zcwai98

Typically one doesn't update individual rows of data once it's stored in Domo. Mark is correct you can transform the entire dataset (and just define your transformation to target an individual row) ... but that's typically not how Domo was intended to be used. Depending on your degree of expertise you may just want to…

is your question "why did the dataflow fail"? or is it "how can i tell if a job that failed actually failed and then seconds later the task reran and it was fine?" the first one. talk to support. but also it was probably just a hiccup. the second one. you can't. failure is binary and therefore triggered the email. at the…

@swagner is it actually a link to page -100000? b/c that's the overview page. they would have to have the card on their over view.

@MichaelClark and @MarkSnodgrass 1) Michael's card looks the same because while he is showing max(date) he also has date on the axis hence why the data isn't changing. to put on the technical lens: your SQL query has become select machine, date, max(date) from table group by machine, date date and max date will always…

+1 for Mark's advice. Please state in 'plain English' what you're trying to accomplish. I don't understand why you're taking the cumulative sum of contribution sorted by video_plays desc. it's probably not accurate to assume that you can take a cumulative sum per day and domain. if i had to guess you're trying to calculate…

Read the linked documentation carefully. There are some unexpected problems regarding NULL handling in etl. That said, upgrading from Magic 1 to Magic 2 is orders of magnitude faster and you can write significantly more efficient dataflows using the Formulas tile.

@GrantSmith you can't filter on window functions in analyzer unless you turn on the feature switch "enable filter on aggregates". also, while sum(sum(1)) .. should work, you may consider sum(max(1)) over ... this will give you a dense_rank instead of the count of rows (just in case you have multiple rows per machine on a…

Thanks for the mention @MarkSnodgrass . If it were me, I'd create a table with two columns. Date and PromotionTitle. Then JOIN that dataset to your transactions. Then use CASE statements to compare PromotionTitle = BlackFriday2017 and BlackFriday2018.

@Genival_Junior , you can't. You would need a custom app for that. In order to do what you've describe, your beast mode for the p_filter would have to be able to perform a LIST_AGG() to collapse all the available values spread across rows into one row. I recommend finding a different solution to address your use case.

@bigdatadojo2000 it's a premium feature. Ask Domo about White Labelling.

is this a new connection? or did you alter the schema of an existing report. There's an SFDC connector setting that can prevent Domo from changing the schema if you add new columns to your report.

do you have Date in the Sort clause?

put a space in front of the lpad or a '.'

Domo broke / changed functionality in product. lag(count(`ID`)) over( order by month (`Date`)) you have to add the month(`Date`) column as a real column in the dataset. Also be careful, laging by month(date) will lag 12,11,10,9, 8 but won't lag with respect to the year.

You're probably not going to get away from showing the value on the last day AND dynamically changing the date grain of the viz without restructuring your data. If it were me, I would APPEND the data for each of the Date grains you're interested in, then add a constant "Date Grain" that switches to "by Day", "by Week", "by…

Domo will frequently take it's "best guess" on the data type as you import it. unless you're importing it with Workbench I don't believe you can explicitly set the data type. what you can do in MySQL or Magic 2.0 is use an LPAD() function to Left Pad the data. https://www.w3schools.com/mysql/func_mysql_lpad.asp

in magic etl add a constant, 1, called temp add a rank and window tile. rownumber order by temp no partition. in a dataset view rownumber() over ()

@walker_page Domo support would be the best person to direct that question to as they do have access to error logs. that said, it looks like you're pushing 9.3M rows of data with each push. Is that a full replace or an APPEND? if it's a replace, can you adopt an incremental load strategy?…

@estelle531 you would need to build the universe of template rows at the granularity you want to be able to filter / pivot your data on. in this video I describe it as "building the universe" of options https://youtu.be/Xb4QgKYgaqg?t=168

@estelle531 , @MarkSnodgrass is correct, you can fill NULLs with 0 ; however, that only works if there is a row in the dataset for Type B on that date (or whatever the rest of your criteria are). Domo cannot generate data for an axis if the data doesn't exist. If Type B doesn't exist in your data, there's nothing to fill.…

@Salmas how do you expect this to behave? Look at the inside WHEN MAX(`Day`) = DAY(MAX(`Day`))-1 THEN... that can NEVER be the same ... because MAX(DAY) can NEVER equal MAX(DAY) -1 . Try putting your data into EXCEL and figure out how you'd construct the answer... You could use a Period over Period Chart For greater…

side note... rewrite your metric CASE WHEN `Metric` = 'C' THEN sum(sum(`Value`)) over(partition by YEAR(`Date`), `Metric` order by `Date`) ELSE 0 END Avoid putting aggregations inside of a CASE statement. usually leads to heartache. Given that it looks like you only want your aggregation to work IF the metric type is C.…

Hey @JustinB Did a little tutorial for you on YouTube. If you're in the Domo-dojo instance, here's a link to the Dataflow https://domo-dojo.domo.com/datacenter/dataflows/53/graph Link to DataCrew post https://datacrew.circle.so/c/articles-and-knowledge-base/tutorial-buildaverageofanaverage

If i had to guess, when Domo previews your data (it scans the first N-thousand rows) it determined your data type to be type Number. When it got to N-thousand +1 row it came across the text 'nan' which obviously is not a number. hence why it failed. Can you reupload your data? If you have Magic 2.0 you can explicitly tell…