Forum Discussion

joaoantunes's avatar
joaoantunes
Frequent Visitor
6 years ago
Solved

Resource utilization per day

Hello,

 

I have a bunch of information that i've get from a projects platform on  JSON format, this information contains things like tasks name, tasks owners, start date, end date, project name etc.

 

I need to create a simple visual way to see this info like on a timeline or simple "excel" view (tabular)

 

The demand of the customer its:

  • Users on the lines
  • Dates on the collumns (daily)
  • Task info on the blocks
  • Projects name by color

So, more or less like this:

 

Assignee are the users.

 

The main dificult i get here its a simple way to generate a timeline using the collumns, i need to have all the dates even if there's no task for anyone on that date.

 

Also, the dates should have the weekday too (monday...).

 

How can i acomplish this? i was thinking on using PowerBi but if i need to get to the basics (ex. Excel with automatic import of the JSON) i don't mind.

 

Thanks

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Heya,

     

    You can use a matrix visual and plot a date-table as the columns. Linked to the orignal table. Then plot users on rows and task would be value in this case. 

    Then you can use conditional formatting to create colors for projects.

    Goodluck.

7 Replies