I'm trying to make a stacked bar chart.
The way the data is structured: there are 7 Milestones to choose from for each Record, you will have multiple Milestones for each Record. Some could have none, others could have all 7. There are 4 main Milestones that need to be analyzed.
The goal of the stacked bar chart is to show a count of Records that have designated any of the 4 main Milestones on the bottom, and those that have not on the top.
Attached is my standard bar chart, the dimension is:
=if([Milestone] = 'Key Milestone 1', [Milestone],
if([Milestone] = 'Key Milestone 2', [Milestone],
if([Milestone] = 'Key Milestone 3', [Milestone],
if([Milestone] = 'Key Milestone 4', [Milestone]))))
The Measure is:
Count(DISTINCT{$<[Milestone] = {"Key Milestone 1", "Key Milestone 2", "Key Milestone 3", "Key Milestone 4"} >} DISTINCT [Record])
I got the 'yes' portion to work (attached) but am going in circles how to fill in the top part with the nos.
Some ideas were a simple calculation of the count(distinct() measure minus the total, that didn't work due to multiple selections.
The app is a binary load from a QVD so I am unable to make a new field, so my calculations need to be done in the app.
Any ideas?
