Daily number of prescriptions displayed in a custom reportSOLVE
I'm facing a problem to display a specific data in my Dashboard.
I'm working with doctors and I'm using Hubspot to follow my clients activity on my website. I've linked Hubspot with my website using API so, when a user creates an account on the website, his profile is directly created in Hubspot. And when he prescribes from my website, the "prescription" property in his profile is automatically updated and gets +1.
Now I'd like to create a daily prescription report that will show how many new prescriptions were made by my clients (total number of new prescriptions) every day.
I created a new custom reports and decided to display Create date measured by the Total number of prescriptions.
Unfortunately, it seems that the create date is the Contact's create date, and not the Prescription's create date. So the graph show the total number of prescriptions according to their doctor's account creation day.
Is there a way to do what I want to do and display the daily number of prescriptions ? Do I need to replace "Create date" by something else ?
Thank you for your help.
Solved! Go to Solution.