daily average of activities in data studio

Enrique Fernández
Enrique Fernández Member Posts: 1
Photogenic First Anniversary
edited May 2022 in Sales CRM #1

Hello. I am currently working with data studio to see my statistics from my pipedrive CRM. However, there is a metric that until now I have not been able to formulate. My advisers carry out a number of activities on a daily basis. However, I am interested in knowing, according to the days that have elapsed in the month, how many activities they have carried out on average per day.


The field that has that information is reflected as text. Therefore, when entering the average formula, it tells me that it must be numeric.


What I can do?



  • Manuel Oliveira
    Manuel Oliveira Admin Posts: 1,143 COMMUNITY MANAGER
    5 Likes First Answer First Anniversary First Comment
    edited July 2021 #2

    Hi @Enrique Fernández , I have adjusted the topics in your post to make it more relatable to your question, and hopefully get you the answer you are looking for :)

This discussion has been closed.