Averages for columns with data types Duration and Percentage

[ermak]

Hello.

Сould anyone tell me how to reflecting in the reports in the table of averages for columns with data types Duration and Percentage? For both columns in the report the average value reflects decimal number for some reason.

                 ----->                       

[v-piga-msft]

Hi @ermak,

Based on your imformation, I'm still a little confused about what is the logic of the avergae for the date duration and the percentage.

Do you want to average the date as sceonds? 

Could you describe your requirement in more details?

I would appreciate it if you could share your desired output so that we could help further on it.

In addition, you could refer to the similar thread below.

Average of percentage

How do an average for a column type date

Best  Regards,

Cherry