Forum Discussion

larrylob's avatar
larrylob
Regular Visitor
6 years ago

Create an progress visual with due dates

Hello,   I am trying to recreate a visual that is similar to one that was created in Excel. The visual uses dates of when different stages of document packages are due. Each package is a row in the...
Need Help
larrylob's avatar
larrylob
Regular Visitor
6 years ago

Sorry, posting issue. Just reposted. Thanks

amitchandak's avatar
amitchandak
Super User
6 years ago

larrylob 

I do not remember some visual very similar to that. 

You can take date diff between the dates and plot those. Or take date diff from a date selected in the slicer and plot.

  • larrylob's avatar
    larrylob
    Regular Visitor
    6 years ago

    Thanks for the advice. If I use the date diff wont this only plot the number of days between each date an not the actual date?

     

    Thanks,

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi larrylob,

      In my opinion, I'd like to suggest you create a table to expand records based on two date ranges that defined by three date fields and link with the raw table id field. Then you can use new table date fields and original table value filed to analyze across multiple date fields.

      If you confused about coding formula, please provide some dummy data to test.

      How to Get Your Question Answered Quickly 

      Regards,

      Xiaoxin Sheng

      • larrylob's avatar
        larrylob
        Regular Visitor
        6 years ago

        Hello,

         

        Sorry it took so long to answer but considering the issues going around the world right now I had other issues to deal with. 

         

        A sample excel sheet can be found below. 

         

        LotConstruction dateDue Date for commentsActual Date for commentsDue Date
        Final        		Actual Date
        Final
        FN012020-05-22N/AN/A2020-05-29 
        FN022020-05-22N/AN/A2020-06-05 
        RC052020-08-172020-06-10 2020-07-10 
        RS012020-08-142020-05-29 2020-06-29 
        RC022020-08-062020-05-20 2020-06-17 
        RC042020-06-162020-05-08 2020-06-08 
        RO042020-06-112020-04-29 2020-05-28 
        RE022020-06-112020-04-17 2020-05-15 
        RC012020-05-292020-03-27 2020-04-28 
        RO012020-05-212020-03-18 2020-04-17 
        RS022020-06-172020-03-06 2020-04-03 
        PO012020-01-072020-02-28 2020-03-27 
        RO022020-06-122020-02-26 2020-03-25 
        PC012019-11-272020-02-21 2020-03-20 
        RE012020-07-082020-02-142020-02-172020-03-132020-04-02
        RC032020-06-162020-02-052020-02-052020-03-04 
        RO032020-05-042019-12-102019-12-192020-01-21 

         

        I'm not sure I follow you when you say to create a table to expand the records. 

         

        Thanks for the help.