Forum Discussion

stsm_glen's avatar
stsm_glen
Brass Contributor
Jul 20, 2018

Gantt chart doesn't like percentages?

Hi everyone,

 

I'm having some issues getting a Gantt chart to work with percentages. My dataset is basically a list of orders. Each order has a quantity ordered, a quantity completed for that order, and then I also have a calculated column that displays the percent complete for that order (settings shown below:)

So as you can see, this is supposed to show a calculated percentage with 0 decimal places. In the AllView view, this looks just as I would expect it:

Now I have another view which is a Gantt chart. I have it configured so that the Percent complete pulls its data from my Completion calculated column above. When I switch to the Gantt chart view, it errors out with "This list cannot be displayed as a Gantt chart because it lacks required fields." If I make the Percent completed field optional in the Gantt chart configuration, it is able to load without a hard error. However, the Gantt chart ignores my configuration of the column insofar as decimal places and percentage values are concerned:

So I don't seem to have any options for displaying a nice completion value anywhere in the Gantt chart. I understand from https://social.technet.microsoft.com/Forums/sharepoint/en-US/6498a9f2-fe65-4bcf-a67d-40200adf6afc/using-calculated-fields-to-show-percentage-complete-in-a-gant?forum=sharepointadminlegacy that this is a bug in the Gantt chart, that it's unable to display calculated values. Is there any chance of any of these bugs (displaying calculated values or respecting column configurations) being fixed?

 

Thank you!

 

 

2 Replies

  • The Gantt view is a really old view in SharePoint that you can still use it...might I ask you a question about your list: do you have required dates fields in the list? You need them so the Gantt view can work
    • stsm_glen's avatar
      stsm_glen
      Brass Contributor

      Hello Juan,

       

      Actually, it looks like the date(s) fields in my list aren't required. I noticed that the Gantt chart supports showing undefined dates by displaying a different box though. I thought it odd that only percentages seemed to be confusing it though. Are there other displays in SharePoint that would make it easy to show my data like the Gantt chart?

       

      Thank you for your response!

Resources