# Utilization rate - How to visualize and process timeseries data

**URL:** <https://community.appfarm.io/t/utilization-rate-how-to-visualize-and-process-timeseries-data/1299>\
**Category:** Ask the community\
**Created:** [July 1, 2024, 2:33pm UTC](https://community.appfarm.io/t/utilization-rate-how-to-visualize-and-process-timeseries-data/1299 "2024-07-01T14:33:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![OleSorheim](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/olesorheim/32/1171_2.png) [@OleSorheim](https://community.appfarm.io/u/OleSorheim)\
**Post date:** [July 1, 2024, 2:33pm UTC](https://community.appfarm.io/t/utilization-rate-how-to-visualize-and-process-timeseries-data/1299/1 "2024-07-01T14:33:45Z")

</div>

Our data consist of a series of units that are linked to projects. We have created an object class to store the data of how long a unit is on a specific project. This object class, UnitHistory, is linked to a single unit and a single project.

Now I want to visualize the data in UnitHistory as a timeseries. Any suggestions on how to proceed? Specificly I want to visualize how long a unit is on projects vs how long it is on storage/ service (storage and service are also projects).

Specific questions:

- Should I create a new object class that tracks utilization rate?
- How do I get hold of the data in UnitHistory and visualize it efficiently?
- Do I need an additional object class to visualize time on x-axis? F.eks have an object for each month in the year, or a single object holding all months?

Edit:  
I think I need to iterate UnitHistory per Unit (loop inside a loop), which is not very efficient. Also I dont want to do this in runtime, since that might also slow down the app.

All suggestions is welcomed 🙂