Forum Discussion

Flexx's avatar
Flexx
Frequent Visitor
3 years ago
Solved

Need help sorting work by start, end

Hello, 

I'm a very new user and need some help.  I have a data set with a request number, start date, and end date.

I would like to show how many of these requests start, end, or have the same start and end - based on date selected in slicer.

I"m not sure how to do that.  Any help would be greatly appreciated.  I've serached this forum for something that might help, either I was searching for the wrong thing or this question has not been answered before.

 

thanks.

 

Need Help

6 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage
    3 years ago

    Data in the form of a picture is not suitable. Please give us text data that we can at least copy. Best would be to give a link to a file with data. Such a file would reside on a shared drive, like Google Drive, OneDrive... Don't forget to grant access rights if you decide to do this. THanks.

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    Hi Flexx ,

    do you want to know how many requests start and end the same day? Sorr, but I want to be sure what is your expected result

    • Flexx's avatar
      Flexx
      Frequent Visitor
      3 years ago

      Not sure what happened there.  thank you for your response.

       

      im looking for three measures

      1.  how many requests start

      2. how many requests end

      3. how many requests start and end on the same day.

       

      i need to display these measures when selecting a date from a slicer.