Best Of
Display Row count at every step in Magic ETL
Currently if you want to know your row count in Magic ETL at any stage other than the out put, you have to place a few temporary tiles to get there. I.E. add a rank and window tile to establish a Row Number column then aggregate with a group by to get the max row.
Would really love if each tile could show the rows contained within, so if you're losing or blowing up data it's easier to find where the changes are happening. Would save a TON of time.
I realize there may be limitations because Magic can only preview 400k rows - so just like on a table card if you're over the limit of data that can load, it would be fair to say so. I'd rather be limited to how much data I can know about than not get any row counts at all.
RobynLinden
Regex in Formulas in Views and in Formula ETL Tiles
I would like to be able to use regex to match values in formulas. Both in views and ETLS Such as this. I am using this to validate some data in a view formula
CASE
when `Field` like '[0-9]{4}\-[0-9]{4}\-[0-9]{3}' then 0
when `Field` = '' then 0
else 1
end
Byboth
Re: Turnover calculation query
Nice! Have you noticed any changes in values to the Monthly Rolling Turnover?
amehdad
Re: Turnover calculation query
Before delving into your working, can I confirm that you have Window functions enabled, in your instance, from your customer success rep?
amehdad
Re: Turnover calculation query
Hi @Abhijith, so you need two calculated fields for 'Exit' and 'Employed/Headcount'. Using the fields from the ETL, the Exit beast mode would like:
''' SUM(SUM('Terminated')) OVER (PARTITION BY YEAR('Last Day of Month'), MONTH('Last Day of Month') ORDER BY 'Last Day of Month')
You would then need to calculate the rolling average headcount for each month (year vs prior year), which I don't know how to code dynamically.
After getting those two working, you would combine to create the annual turnover rate calculation.
amehdad