-
Re: Possible to filter on one dataset based on the results of another dataset in a page?
@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 …1 -
Re: Exclude first Value - Rank & Window
+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 probab…1 -
Re: PYDOMO SCRIPTS DEPLOYMENT
Domo Magic ETL scripting tiles. https://www.youtube.com/watch?v=lhj9zcwai983 -
Re: How can I compare YOY data with an offset of a couple of days?
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 P…1 -
Re: Difference between preview and data table
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 mon…2