I need help creating this custom report with custom properties. I just cant do it after trying for a long time. Anyone can tell me how to handle this?
“Portfolio Depth” and “Portfolio Width” contain values from 1 to 10 and every customer is rated in these values.
Somehow it always jumps back to have “distinct count” on the visualization.
Any ideas?
Hi @JViohl
If you’re using a Scatter Plot Graph the below applies:
In the custom report builder, you can select scatter plot as a chart type. While chart types such as bar and line graphs enable you to measure data on X and Y-axes, scatter plots can be useful for viewing relationships between data across multiple variables. Scatter plots can highlight trends, clusters, patterns, and relationships between numeric data. For example, you could create a scatter plot to report on whether or not providing a larger discount leads to great profit.
In scatter plot charts, you can only add measures and date-based fields to the X- and Y-axes. Any field you add to these axes will be converted to a measure automatically. Learn more about dimensions versus measures."
Can you confirm what the property types are of the above properties you’ve mentioned? It might be required for these properties to be created as Number Properties instead of dropdown-select/radio select.
Many thanks,
 | Matt Aire HubSpot Freelancer | Founder @ pocketpros Let's chat HubSpot - book a meeting |
If my reply was useful and helped answer your question, please mark it as a solution to help the community!
Hey @JViohl
so as Matthew mentioned
in order to be able to build this graphic
the property type should be numbers
if you have this in text or any other format this wont work.
You can also try another type of chart to see if it builds up
but it 'd probably happend the same thing.
Let us know how it goes.
