I have made a vertical bar graph in Kibana and all seemed to be good at first. However, when I was checking the values against the buckets I found some issues. The Sum being displayed is incorrect for 8/10 buckets. So for example, bucket 8 shows a sum of $1200 on the bar graph, but the actual value is around $700. When bucket 8 is clicked to filter the dashboard it displays the correct amount.
I checked the dev console to try to find the issue and discovered that only 19/28 documents are being read in. I believe that it is skipping over data stored in certain shards.
Can I fix this in the visualization/settings or do I need to manually assign fields to certain shards? If the latter is my only option, what is the safest way to go about doing so?