I created a vertical bar chart that has the following settings:
The y axis has an aggregation of "Average", a field called: "itemprojectionfactor" which is a number (float), and a label: "Sum of Purchased Item Projection Factors".
Under "Buckets", I have an X-axis with an aggregation of "Terms", a field called: "itemname" which is a string, and Order By: "metric: Sum of Purchased Item Projection Factor", with a label: "Purchased Item Name".
Under that, I have a "split bars" subaggregation of "Terms", a field called: "consumername" which is a string, and Order By: "metric: Sum of Purchased Item Projection Factor" with no label.
My bar chart is correct in that it has multiple bars next to each other (for each itemname) across the x axis for "Purchased Item Name", and along the y axis for the Sum of Purchased Item Projection Factor". So each bar is split based on a consumer name for that item and its average projection factor. The ruler on the y axis reflects the sum of the average projection factors for each consumer for a particular item (items go along x axis).
The bars are split (have horizontal lines going across them) along the Y axis for each consumername (which only appears when hovering over the bars".
What we would like to do is use this aggregation and our correct final table, however, we do not want to display the split lines for the consumername in that it is a private field that we don't want displayed anywhere, however, we do want it used in our aggregation and the creation of the final table. We just want our bars to be one color without any splits for consumername. This way, it will look like "Sum of Purchased Item Projection Factor" for each "Purchased Item Name".
Is there any way we can use all three fields to come up with the visual data table, but leave out the actual consumername and the split lines/change of colors in the bars?