Regarding Objective 1&2, you just have to use Summarize tool. Pls refer to the attached WF.
When it comes to analysis, it is difficult to provide the generic solution, it ttally depends on your goal... but ,I say, first thing to do is to make some visualization to get insight.
For example, regarding Transfer data, we can create Heat Map by Interactive Chart tool to know which Entity has the most/least numbers of employees leaving/accepting like.
what if i want emp id, name , transfer date and old entity , new entity for all and then new column maybe (formula tool) stating entity changed - yes or No
What i did is- i did group by name and emp id as well
and then added formula tool
that
entity changed: iif(old=new),”no”,”yes”)
but the problem is after this if i want to see total new entity wise count i am not getting total count instead because of name and emp id group by i am getting output like this:
Empid. Name. Old entity new entity Entity transfer total
Is it solved or still you are looking for solution. If you are looking for solution, then please again state the question and output needed below. Might help you out.
Is it solved or still you are looking for solution. If you are looking for solution, then please again state the question and output needed below. Might help you out.
I want to built a logic behind two sheets can someone help me to go through this?
sheet 1 : Termination Data
Objective: is to find no of terminations per entity.
sheet 2: transfer data
objective : is to find no of transfer from one entity to another and no of transfers entity wise.
And if any analysis can be done through alteryx on this
output required:
1)emp -id.
2) name
3) old entity
4) new entity
5) entity transfer - yes/no
6) entity wise count (new entity)
example
01. Abc. Sales. Marketing. Yes. Marktng:2 Sal-1
02. Cde. Sales. Sales. No
03. Rst. Finance. Marketing. Yes
where marketing:2 and sales:1 is the new entity total.
also interactive chart for both if possible to do analysis
