Best Of
Re: Warning: Not all the data is shown
Is there a plan in place to expand the number of rows that can be shown? I too have a table with less than 1000 rows and get this message.

Re: Warning: Not all the data is shown
If you want to see all the data, then you will have to export the table card (drill down) to a spreadsheet. For some time now, the data that is shown in the table cards has been limited.

Re: Warning: Not all the data is shown
Hi, Xerva. Thanks for the reply. I have created a simple table chart and it is not showing all the rows. I think it is limited 700 rows. Please find the attached screenshot.

Re: Display Row count at every step in Magic ETL
This would also be helpful to see as an additional column in the run history so we can compare "Rows Processed" to "Output Rows" at each step.
Re: Display Row count at every step in Magic ETL
Love this idea! I always have to put output datasets just to check row count when I am troubleshooting to make sure I did not blow up a join.

Re: Display Row count at every step in Magic ETL
Right, in the preview - maybe right here.
I want to know how many rows are contained in the step. So if I have 1000, I blow it up to 2000 on a join, but then land with 500 due to a group by -- just tell me that in the header of each tile after I run a preview. If 500 is what I wanted, then I'm happy.
Re: Card updates later in the month than other cards - Beast Mode to keep previous value until update?
What are you using for your date range filter? Do you have set to this month? Or do you have it set to All-time?
If it is set to this month, then it will always show the current month regardless of any beast mode you create. I would probably set it to the last 2 months and then use a beast mode to do the toggling between months based on what day of the month it is with a nested case statement.
Re: Card updates later in the month than other cards - Beast Mode to keep previous value until update?
@Joe_M Would using a beast mode like the following work for the date on those cards?
case when DAY(CURDATE()) < 7 then DATE_ADD('Date', interval 1 month) else 'Date' end
This says whenever the day of the current month is before the 7th, add one month to the dates in the 'Date' column (show the previous month). On the 7th or after, don't modify the date (show current month). Not 100% sure if it will work but worth a shot.