Skip to main content

Hi,

 

I have a table with a series of stories per date and status. I would like to show the story points if the status of the story has changed in the previous month. How can I do this?

 

Please find attached the workbook.

 

Thanks a lot,

2 Antworten
  1. 9. Jan. 2024, 23:48

    @Ester B​ 

    Hi, in this case you may use:

    LOOKUP(MAX([Status]),-1) <> MAX([Status])

    OR ISNULL(LOOKUP(MAX([Status]),-1))

    @Ester B​ Hi, in this case you may use:LOOKUP(MAX([Status]),-1) <> MAX([Status])OR ISNULL(LOOKUP(MAX([Status]),-1)) Take into account, line 2 is to show the ticket initial status. 

    Take into account, line 2 is to show the ticket initial status. Attached you will find the workbook.

     

    If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego Martinez

    Tableau Visionary and Forums Ambassador

0/9000