https://communities.sas.com/t5/SAS-Visual-Analytics/Using-Calculated-Items-in-SAS-Visual-Analytics/m-p/949345#M18442 you can use the formel to do this, and with _ByGroup and Aggregated (simple) Operator "Avg", the average value will be automatically calculated and displayed by filter/kategorie Tue, 29 Oct 2024 11:25:57 GMT Woo23 2024-10-29T11:25:57Z https://communities.sas.com/t5/SAS-Visual-Analytics/Using-Calculated-Items-in-SAS-Visual-Analytics/m-p/948854#M18436 <PRE class=""><SPAN class="">how to create a formula for average completion time per day or hour in visual analytics with columns or fields created_at and completed_at. Thank you</SPAN></PRE> Thu, 24 Oct 2024 04:12:56 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Using-Calculated-Items-in-SAS-Visual-Analytics/m-p/948854#M18436 Ramotiau 2024-10-24T04:12:56Z https://communities.sas.com/t5/SAS-Visual-Analytics/Using-Calculated-Items-in-SAS-Visual-Analytics/m-p/949345#M18442 you can use the formel to do this, and with _ByGroup and Aggregated (simple) Operator "Avg", the average value will be automatically calculated and displayed by filter/kategorie Tue, 29 Oct 2024 11:25:57 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Using-Calculated-Items-in-SAS-Visual-Analytics/m-p/949345#M18442 Woo23 2024-10-29T11:25:57Z