Forum Discussion

Hesselvdk's avatar
Hesselvdk
Regular Visitor
9 years ago

How to calculate storage (MB)?

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?

2 Replies

  • Hesselvdk's avatar
    Hesselvdk
    Regular Visitor
    9 years ago

    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's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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.