Abhijith Member

Thanks, @amehdad Thanks, @GrantSmith

Hi @GrantSmith Thanks for the suggestion. Based on your feedback I managed to find the turnover % for a month. But now if I want to find the turnover% for the other months, is it possible to do that in the same beast mode or do I need to create a separate beast mode? I'm using the bogus dataset shared earlier.…

Hi @amehdad I got those calculated fields for 'Exit' and 'Employed' but yeah I was stuck at the part where to generate dyamically. Also is there any way I can sum up all the 'exits' for a period(say 12 months fixed) and then I can use it to work out the turnover rate calculation.?

I needed direction on how to work out the formula for the calculation in the excel file attached at the beginning of the thread. Especially how do I identify the average of the first and last month for each month's calculation.

Hi @amehdad They have now confirmed that the windows function has been enabled. Can you please check and advise how do I take it forward. Thanks once again.

@amehdad I'm still waiting on the feedback from Domo support. They have asked me to wait. I'll revert back to you once I received confirmation from their end. Thanks

Hi @amehdad , Let me check and revert back. Thanks

Hi @amehdad , Thanks for the write-ups from @GrantSmith Based on that I tried to work it out and I'm not winning. My basic objective is to get the total sum of 'terminated' for that period(it is always for 12 months) so that I can use it in my calculation. Kindly advise what might be wrong. Thanks

Hi @amehdad , Thanks for the write-ups from @GrantSmith For some reason, I'm not able to view the cumulative effect as per the windows function. My intention is to get the grand total of all the 'Terminated' for these months so that I can use them in the turnover formula. Please advise if I'm going in the right direction.

Hi @GrantSmith : I thought so but I got confused with the 'dt' column from the Domo calendar. Let me check it out and revert. Hi @jaeW_at_Onyx : Thanks for your valuable input, it is really appreciated. I'll explore it further.

@amehdad : Great thanks mate, that worked @GrantSmith : So I began unpacking and noticed this strange bit. The column 'dt' gets identified in Filter rows but not after that. In the 'Add formula 2', the 'dt' column is not getting detected. Is there anything I could check it? Kindly advise. Thanks

@GrantSmith Thanks for your message. A quick query, when you mentioned I could copy and paste into the Magic ETL, did you mention the below as I noticed it is more of a drag and drop. Or perhaps is there another option. Kindly advise.

Hi @amehdad , I was just exploring and then based on some hints, I managed to introduce a date dataset into the ETL and then ran into some other issues which I am sorting out. I do not have any other ETL which I could use it join based on ID. I will revert back to you soon. However I came across this (How Many Staff Do We…

Hi @amehdad , Thanks for your response. But in this case, with the first Q, this will only show the total hired at that month. For example, it will not show in the below format, wherein it summarises the total for that month i.e. provide a total number of employees working during that month. SEP OCT NOV DEC 440 420 430 450

Done.