Skip to main content
J
JaneSt1
New Participant
March 4, 2021
Question

FTE needs charted by ROLE

  • March 4, 2021
  • 3 replies
  • 698 views

Hello advanced Reporters...trying to create a stacked area chart showing FTE needs over time by role.

1. Can export to Excel and create chart, but data not exported as numbers and can't find way to easily transform.

2. Created Assignments report which gives %Allocation and can be line charted. Could create calculated column in view to transform % into FTE, but this won't chart. If we could convert % and aggregate and chart, we would have it. @Cori Stampf‚ @Leslie Scott‚ @Shey White‚

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    kynabaker16
    kynabaker16
    Employee
    March 11, 2021

    Hi Jane,

    I took this to people smarter than me and they suggested the following. Does this help?

    Create a system wide calculated field and then you would be able to aggregate and chart by that. Essentially, it would be the same as doing it as a column, but instead you would need to create the calculated field as a custom field and add it to all of the objects you need the data on.

    Kyna

      J
      JaneSt1Author
      New Participant
      March 12, 2021

      Thanks Kyna...I think we have isolated the problem to being that you can't get allocation date on plannedHours (only on budgetedHour object). If wanted to use Plan to update Budgeted, we could, but then we lose the differentiation between budget and plan that we would like to retain,.

      kynabaker16
      kynabaker16
      Employee
      March 12, 2021

      AH. I see. Well, sorry about that!

      Terms & ConditionsAccessibility statement

      Loading footer...