Forum Discussion
RHTML custom visual, data loss results in misleading plot
This would definitively be a part of the problem, thanks for letting me know! Unfortuneately, it didn't fix the issue. For example, if i restrict the data (PBI filter) to a year with few observations, it is still wrong (even after updating top "count":30000). I'm assuming there is some R function that isn't supported in R?
Hi Anonymous,
I don't do much with R, but with custom visuals in-general, they will cap at 1,000 data points by default unless the dataReductionAlgorithm is updated to declare your visual's data point limit (up to a maximum of 30,000).
If you haven't tried this, here's the relevant section of documentation that explains the default limit and how to configure your capabilities.json accordingly.
Hope this helps,
Daniel
This would definitively be a part of the problem, thanks for letting me know! Unfortuneately, it didn't fix the issue. For example, if i restrict the data (PBI filter) to a year with few observations, it is still wrong (even after updating top "count":30000). I'm assuming there is some R function that isn't supported in R?
Unfortunately R isn't really my wheelhouse, so I can't offer anything to help on that side of things; just that the capabilities are usually a common sticking point for data being limited in the visual's data view. Hopefully someone else may be able to clarify that part for you 🤞
All the best,
Daniel
Turned out that I forgot to select "sum machine hours" as an aggregation option in Power BI... (my fault). However, your proposal would still be a problem in the next step, thank you for making me aware of it! Power BI is way more fun when you can actually make your own visuals 🙂