Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Transform data_Select start date and end date

Dear all,   Please your help to advise how can I convert below data.   Original data includes 2 columns: activities and date. I want to define the start date and end date of each activities.   ...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Group it:

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     



     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - So put Activities in a table visualization and then put date in twice, once with a min (first) aggregation and then with a max (last) aggregation.