How to calculate storage (MB)?

[Hesselvdk]

Hi all,

I have a dataset with the memory, the total size of each server we host. We measure every day the servers, so we have every day a new record. When I put the data in a line chart you will get weird numbers for every month, quarter and year. You want to sum the daily the memory and the total size and take the average for each month, quarter and year. Is there a solution for this problem?

[Hesselvdk]

Hi all,

I have a dataset with the memory, the total size of each server we host. We measure every day the servers, so we have every day a new record. When I put the data in a line chart you will get weird numbers for every month, quarter and year. You want to sum the daily the memory and the total size and take the average for month, quarter and year. Is there a solution for this problem?

[Phil_Seamark]

Hi @Hesselvdk,

Why not make two measures.  Use a measure that uses the SUM function on any linechart where Daily is your axis.

But then use a measure based on the AVERAGE function for any linechart where you use Month/Quarter or Year on the axis.