1 Reply Latest reply on Nov 27, 2018 8:28 AM by Yuriy Fal

    How to create Burndown Chart with a variable number of records

    Jason Goldkamp

      I posted this on Stack Overflow and didn't get any response, so now I'm trying over here. Here is the Stack Overflow page if you want internet points: Tableau How to create Burndown Chart with changing number of records - Stack Overflow.

       

      I'm having trouble creating an accurate burndown chart. I have cobbled together one with the programming equivalent of duct tape, but I want it to be 100% correct, which it is not.

      Excel Data https://drive.google.com/open?id=1TUtrHj196axGd-Mo5olDg9bMdNjl7ZpO

      Tableau file https://drive.google.com/open?id=1Pn02eydVluE4cRgJQJ3oqvh3gJaDLD03

      So, in the example file above you can see I'm aiming for a simple burndown chart. However, as the project is proceeding, we are finding servers that are not applicable to the migration. So I can't use a static number to begin the burndown chart. I need to be able to subtract the "N/A"s in Status from the total number of servers. How can I go about this programtically?

      Screenshot