daily average of activities in data studio

Enrique Fernández
edited May 29 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?

 

Comments

  • Manuel Oliveira
    Manuel Oliveira Admin Posts: 602 COMMUNITY MANAGER
    100 Comments 5 Answers 5 Likes Community Manager
    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 :)