WizardOz

Thank you @swagner . I also found that View Explorer is unreliable :( and causing problems to down stream users

I just encoutered this issue - I added a fitler today and saved the file. Then I wanted to remove the new fiter I jut setup. it showed first my filters became cal_col1 and cal_col 2 and asking me remove the references. I deleted the fitlers, tried to reset it up, but now it shows the above error and I could not do…

after testing many different scenario, I think the issue is related to the calculated columns, not the size of the view. Here is a work-around : Create view1 from the original data and add all you calculated columns in View1, then create View2 from View1. You are able to swap the dataset with View2 in the existing cards.…

@jaeW_at_Onyx an update: this is very strange - In previous case, I created a new view based on the view-dataset, randomly dropped the columns to 65. Then I can easily swap this smaller view dataset. Now in the actual view-dataset, I cut the columns to 65 (with different columns from previous testing case), but it still…

Hi Jae, I am using the Viewer explorer beta to get s subset from the original dataset. It has about 120 columns with about a dozen of them are the new columns I created based on the beast modes used in the dashboard. It looks like the # of columns is the cause: when I cut the columns to 70, I can switch the dataset without…

Thank you Ashleigh ! it works! Olivia

@jaeW_at_Onyx thank you for the explanation. That is probably why they see different numbers. Creating binary variables in the dataflow is tough for me: because this is a huge dataset with 114 M rows, and we had time-out issue before. So I changed the whole process by running 2018, 2019 dataflows separately (just need…

thank you @GrantSmith. I used saved as a lot, but did not realized I can save as to a new page! Olivia

@marisaborges thank you for your idea. But I am not sure it is doable in the dataflow - this dataset has 120 million rows and 200 columns, in order to reduce the run time, I had to run the whole dataflow for 2018, 2019, and now just run dataflow for 2020 and append to the 2018 and 2019 dataset using data assembler. Not…

Max(date) is the first thing I did, but unfortunately, the new textbox feature does not show this max(date) in the filter section

@jaeW_at_Onyx Hi Jae, Thank you fo the video - I now understand the concept now. I will work on the magic ETL . But here is something I wanted to understand in general - When you create this new dataset in ETL, do you only select the fields you need or all fields from the original dataset in the numerator dataset? My…

This is simplified dataset, I would like to get the active user % in certain time period - people can choose time range. However, because I used Occured at to create a date fitler, whenever a date range is selected, it always show 100% active user%. Thank you. USERIDuser groupOccurred…

Hi Jae, Wonder if it is just me - I coudl not hear anything in this youtube? I checked other youtube videos = no problem with sound. Can you check and let me know? Thank you.

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-to-calculate-usage/m-p/47478#M8067 Thank you Jae, I have created a new topic. Olivia

Hello, Jae, Need your help with another scenario. I could not figure it out. Can you please let me know how to do it or if it is possible to do it? Thank you very much! This is what I have: Content ID and Product are meta data for a full list of documents. When an user used a document, such as download, viewed etc, there…

Thank you for your help! I applied Jae's approach and get it work. Olivia

thank you very much Jae! I watched your whole section of youtube on this subject, you explained it very well. I am able to modify it and get it work for different emails within the same campaign and show the performance. I am going to apply this to another senario I have, hope it will work. But may reach out to you again…

Yes, my beast mode is an aggregated formula. I am very interested in this beta, can you please give me more info? This will save me tons of efforts becuse in some cases, I had to make the calcualtion in the dataflow. Thank you. Olivia sum(case when `stc_indicator`=1 then `amo_cost` end)/((COUNT(DISTINCT (CASE when…

Hi, Superman, can you also help me with this -- I need to report on Active user/Inactive user by group. I am able to report on overall active user /inactive user, but as you have figured out in the previous post, the occurred date is only associated with Active user, meaning when there is an action, there is a date…

Superman, You are genius -- It works now. But I wanted to point out that COUNT(DISTINCT case when `useractivity_status` = 'Active User' then `usersid` else 'Inactive User' end) -1 reduced the active number by 1. For example, I suppose to have 127 active users, using -1, I only got 126. Best, Olivia

Thanks for the idea -- I grouped date by month, but nothing changed :(

(COUNT(DISTINCT case when `useractivity_status` = 'Active User' then `usersid` else 'Inactive User' end)-1)/COUNT(DISTINCT `usersid`) I changed the beast mdoe to this and also grouped date to month, but got the same chart - still 100% active users. I thought this is an easy chart to draw :(

I did not set up anything in the line chart.

Hi, Mark, it does not work for my case because I do need to count(distinct). The userid is recorded for every action an user took. I need to remove the dublications.

Hi, Superman, I actually wanted to create a line chart to show the active user % overtime. But I got a line at 1, so I try to use table to check the data. I do need to count(distinct) because an userid is recorded every time there is an action.

Thank you Superman! It works perfect. Olivia

Thank you very much! Olivia

Hi, Superman, Thank you very much! It works perfect. Best, Olivia