Forum Discussion

Premlatapandey9's avatar
Premlatapandey9
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

How to store data in the table based on time

Hello Everyone,   I have a table with issues and percentage for current month and average but i do not have any table yet where i can show this avergae is for particular month and for every changin...
Premlatapandey9's avatar
Premlatapandey9
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Hello Anonymous 

 

I think I wasnt able to explain better please have a look below and help me

So I have Table 1 created out of data scores like below 

Table 1   
IssuesName&Percent  
Sales82.86  
Prod21.27  
Eng6.06  
Quality1.09  
Admin1.05  
  Avg of issues for Sep22.47
    
In next month  Table 1 one will have different value    
IssuesName&Percent  
Sales85.86  
Prod25.27  
Eng7.06  
Quality1.09  
Admin1.05Avg of issues for Oct24.06
    
So I want to create another table which can store month wise average data based on Table 1   
Average Table    
Avg of issues for Sep22.47  
Avg of issues for Oct24.06  

 

Thanks and Regards

Premlata