jaeW_at_Onyx Coach

@swagner , here's the writeup for doing it in MySQL before Domo got clever and released the Formulas tile. Complete with video explanation :P

@user018766 "if I include a user details for every activity, the dataset will be too large" how do you know that statement is true? by too large do you mean "too many columns" or "too many rows"? because from the Domo architecture perspective, neither statement is true. "I have an operation where a million rows are…

@joshpropp welcome to the Dojo! good to see you. Do create a dummy account and share content with groups that said dummy account is a part of. While Login As would be nice, given that people can share content with individuals, if you're testing your security setup, being able to control the access you've deployed vs. the…

@MarkSnodgrass i don't think the user is talking about dataflows. but to your question, @mward_meetveracity , that query gets translated into DQL (domo query language) which then gets passed as a query to the Adrenaline data layer. given that Adrenaline dataflows and dataset views are relatively robust, it's probably safe…

case when max(amount) = max(max(amount)) over () then 1 else 0 end would identify the day with the max amount. but i feel like this would give you the max max on every date. only downside of doing it in ETL is you have to carefully consider, do you want the max for all time or for the range of data you're looking at (which…

Without hacking Domo, you can only APPEND or UPSERT data during ingest (not after ETLs have been constructed). That said, if you get crafty you can alter a dataflow to APPEND instead of REPLACE (but not UPSERT) In this video i got the dataflow to APPEND but was unable to get it to UPSERT as desired.

AFAIK the feature Grant is describing is binary. it's either turn off all email communications from Domo or not. I'm pretty sure that's not the experience you want for you users, and certainly not something you can toggle regularly. There is a setting when you manually create a user in Domo to disable the email (i believe)…

@AnwarBham and @GrantSmith On paper I understand the request, in execution that's a pretty impossible ask. Given that in an ETL a field could be generated by one or hundreds of inputs (formula tiles, group by, JOINs, regex) it's pretty difficult to ask where a field was used. also a field could be called anything, you…

@AtitW I don't know the answer to your question, but trying building a dataset view (beta, ask your CSM) or just use ETL to subset your data.

: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…