Analysis and workflow for data

Navya08

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

914E96B2-060C-48A0-A290-C9CAB7915640.jpeg

778BEE74-B610-4FED-8D98-1CA14FD70CF9.jpeg

Workflow

Input

Output

Accepted answers

All comments

Gawa

hi @Navya08

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.

1234796_gawa.yxmd

Navya08

For transfer - i am getting output

old entity new entity and count for new entity

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

Navya08

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

123 Abc. Sales. HR. YES. 1

456. Dgh. Sales. Sales. No. 1

where total is (new entity -count)

Akash08

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.

aatalai

also look at the data investigation pallet that can help provide some inspiration

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703