-
Unique Records in Beast Mode
I have three topics/cards with id's 11631,11634 &11636 and I have many users who completed these topics/cards. Now I want the list of all the users who completed all the three cards in a beast mode calculation. Base dataset would have columns like : card_id, user_id, Time
-
Is there a way in ETL/Reporting to show the cumulative total for every month
I'm trying to show a dashboard where in I need to show the cumulative sum of the user count for every month. Need to have the month listed for which there is no activity also. In the above image, I have data for 2019-07-01 and then there is data for 2020-01-01. I also want to have data to show in between these months and…
-
Calling a procedure in MySQL ETL flow
I'm trying to create a pivot table output using a stored procedure, but I'm getting an error while call the procedure. when I to execute the procudure, I'm getting the error as: Let me know what wrong I'm doing here. Thanks in Advance, Srinivas V