Validate units cost in usage report

[paulobressan]

No description provided.

[rodrigosuaya]

@paulobressan there seems to be an issue on how we are aggregating time, and as a result on the calculation of the minimum_cost as well. The report you shared was supposedly for November, so as a maximum we have 20 days of data (until today). This means that no port should have more than 480hs (20 * 24) of total time, but most of them are showing up to 677hs which is equivalent to ~28 days. As mentioned, the result is that the prorated minimum cost is showing almost full cost for the tier when in reality there are still 10 days left of the month. For example, this is what the report is doing:

When minimum_cost should be something closer to $50 ($80 min fee / 30 days month * 20 days passed)

Also, could you please remove the "hs" from the time column, it makes it hard to work with the column as it brakes the format. 🙏