Forum Discussion
kalpanaV
Helper IV
Helper IVAssistance needed
Hi i want to get the details when they changed to other team. for eg- if you take id 103 , initially in monitoring team and after some days ,changed to linux team in august month. like ...
TomMartens
Super User
Super UserHey,
from your sample data, you just can DISTINCTCOUNT() the teamname for each employee. This would provide the number of changes. Due to the fact that the column Month will be considered as categorical variable with no implicit sequence you can't calculate how many changes have happened until the current Month.
You may consider to change the Month column to the datatype date, eg. 2017-08-01 representing august 2017, now it would be possible to also calculate the number of changes until a specific date, due to the fact that dates have an implicit ordering.
Hope this helps somehow
Regards
kalpanaVHelper IV
Helper IVi tried distinct count but it will show count only. i need, which team they have changed.