How to Fix Incorrect Share Calculation in Summary Row?
Hi All,
I'm trying to calculate category shares for a specific brand. When I filter the report to display a single value in the Item.Brand dimension (values are filtered in the QTY measure) and CAT QTY shows the total category quantities across all brands in rows, the shares are calculated correctly at the row level.
However, the summary row is not calculated correctly, even though the CAT QTY sum is accurate. The report calculates the total of all categories divided by QTY, resulting in a much smaller share.
How can I create a dynamic filter in the report or measure so that when a user selects only one Item.Brand, the selection also filters to include only the relevant categories (Item.Category) associated with that brand? Currently, when I manually filter the report to include only those categories, the total market share measure is correct.
Answers
-
Hi,
My experience with Birst is still limited (a bit more than 1 year), but from what I have seen, share calculations are often troublesome. Yet, I think something may be done to fix the problem, but in my opinion you should share more details about your data model and report:
- Is this Visualizer or Designer?
- A screenshot of your star schema, with the involved Fact and the joined Dimensions, would be helpful
- Please post your formulas for custom measures in the report (I guess CAT QTY and Share)
Also, having a look at the generated BQL query would give a hint on what's going on in the background.
Enrico
0