Forum Discussion

kamalbandam's avatar
kamalbandam
Icon for Helper III rankHelper III
5 years ago

Count employees working for same client for 5 years

Hi,

 

I want here to acheive that if an employee is working for client A for 5 years or 3 years which I should be also able to drag using a slicer and get the list of employees. Any help ?

thanks in Advance,

Kamal 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    kamalbandam , need data for better suggestions.

     

    We can have a column

    Age = datediff([hire date], today(), month)

     

    You can create a bucket

    Switch( true() ,

    [Age] < 12, "Less than year",

    //add others

    )

     

    And can use age or age bucket as filter

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi kamalbandam 

     

    You could add a column into the table to calculate how many years an employee has been working for a client. Then drag this column into a slicer by which you can switch the years. To display the filtered employees, you could put employee column into a table so that it can be filtered when you select a value in the slicer.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.