Hi all,
I want to create a report that shows activities for all employees on my small team, including those who have no activities. Is there a way to do this in the reporting tool?
I created a report that shows employees with activities but can’t seem to have the employees with no data show.
Hi @LMcCoy,
This is not possible at this stage, unfortunately. Reports will only show the existence of data, not the absence, unless there is an actual “0” in a field.
You can upvote the Idea that @JMcElroy created (thank you) and add your specific use case to it: “Ability to include null values in report”. It’s being monitored by the product team and requests are evaluted based on popularity.
Best regards!
I have a similar request… I’d like to show all values of the series on an X Y axis…
We have a productivity report that shows the hours in a day across the X axis ( 8 AM, 9 AM, 10 PM… etc). I’d like to have the series shown at all times, but I’m only getting the hours where there is a value to display. The null value is as relevant as the populated ones. Seems like a simple “Show all values” checkbox would take care of it. Thanks!
Please fix this functionality asap as it hinders our reporting
Hi @LMcCoy ,
The reports will only show the data only if it has value. So, what you asking is not possible as of now.
Hope this helps!
If we were able to answer your query, kindly help the community by marking it as a solution.
Thanks and Regards.
This would be a great addition we use reports to show the preferences for certain items. It would be valuable to see the option with 0 people interrested as well in the same report. Maybe include a checkbox with “show value’s with 0 contacts”
I agree, you need to show 0 values in reports, I am building a line graph to show trends, not being able to show that I have won nothing in august but won a deal in Septemeber, is confusing to my management board and making my data look in accurate. I am going to have to manually create this every month, to show dips in trends.
Below I have attached my example of the report I want to create, the red line is where the dip should be to show no deals won.
Please @hubspot can this be fixed. Its very annoying when all the data is there and your let down by reports.
I’m also dealing with this issue. Would appreciate the upvotes here: https://community.hubspot.com/t5/HubSpot-Ideas/Ability-to-include-null-values-in-report/idi-p/1088274#M201774