14 Replies Latest reply on Jul 29, 2018 8:31 AM by Ombir Rathee

    How do I get the countd based on two date fields in a single view

    Poornima Bharadwaj

      I have a data set with 3 columns project_id, create_date and activity_date. I would like to express the % of projects that are active on a given week  and this % needs to be based on # of projects created in a week. I am not sure how to do a countd based on two date fields and express it as a % in a single view. I have attached a sample data set.

       

      Thanks in advance for your help.