Hello
I'm currently working on a football benchmarking report and need to compare how players are developed (three categories) in the league as an average compared to a selected team.
In the filters shelf you can select team, season and league level.
One bar will be the average for the team, whilst the other needs to be the average for all the clubs in the league to compare against
My issue is to combine these two bar charts (league vs team) into one (bars side by side for each category), so it is possible to compare the set average for the league compared to the selected team in the filters shelf.
What is the recommenced solution to this? Will it be a fixed LOD?
Thanks a lot in advance. Normally youtube have the solution, but I haven't manage to find one for this one.
Johannes
Hey Johannes,
You still looking for a solution for this? You're right! The answer is a FIXED LOD. Check out Creating a Calculation that Ignores Filters
It's always easier to give a more exact answer if you're able to upload a workbook. See instructions for creating a packaged workbook A quick method to anonymize a workbook is to hide any fields containing sensitive information before the data source is extracted. Hidden fields are not included in the final extract.
Hope this helps
