2 of 2 people found this helpful
I think the issue is gaps in Data - Age-Band does not associate with Country or Gender - same way Country doesn't tie back to Age-Band. If you create calculations based on 1st column (see below calcs) and put a view together with 2nd column (see below image) you can see there is no co-relation.
When looking a % of Total - you get below breakdown. Hope this helps.
if [Demo 1 Selection] = 'Age_Band' then [Value] else 0 end
if [Demo 1 Selection] = 'Country' then [Value] else 0 end
if [Demo 1 Selection] = 'Gender' then [Value] else 0 end
Wondering if there is any other way to solve this - I have same issue - any help would be great.
I didn't quite catch the gist, but wanted to toss out and idea and see if it would be helpful.
This uses the method of unioning the data to itself:
This may not be available for all data types, but you could probably accomplishment
it in Prep.
The idea is that the self-union creates a new dimension called Table Name which
you can then use in calculations.
If you are only comparing one demo to another, you can make two parameters
and then selectively filter the CopyA version by parameterA, and then the CopyB
version by parameter. If needed, you could fix the selected value to the entire
set so that you could do a direct comparison between the two selections.
If you want the user to select multiple demos, you can create a concatenated
field of Table Name + Demo 1 Selection and filter on that.
Not sure if this is at all pertinent to your problem, but if it is, it just a
very preliminary step. May not be fully functional for your final graph.
But we can explore that further.
Please see workbook v10.3 attached in the Forum Thread.
Dashboard1 uses parameters, the multiselect sheet uses a filter.
279535bands.twbx 83.2 KB
Thanks everyone for taking the time to contribute to this post.
For the purposes of my analysis I have taken Ankit's answer on board and have gone back to my data and changed the SQL to include more aggregations. It had been simplified too much for the last piece in my dashboard puzzle.
Hopefully swaroop.gantela's answer will come in handy for Andy.