Setting a conditional format on a Full Accumulation chart
Hi I have created a series of charts the first shows simply the average of a dataset, the second shows the distribution of the dataset and the third using the Full Accumulation button shows the cumulative distribution
I would like to set up a conditional format whereby the columns in the last chart change colour when they reach say 90% of the total
Is this possible and can I do it without complicated scripting !!
Re: Setting a conditional format on a Full Accumulation chart
In the bottom chart I am not using an expression rather I am just using the Full Accumulation functionality to create the visualization. I am thinking I probably need to use an expression which I can then do the arithmetic off for the conditional format I am just not sure what it is. Will look closer at both pieces of feedback now - Thanks Both
Which gives me the accumulation I am looking for but I am still struggling to do the % part despite reading many of your helpful posts
So I have release time as a dimension and from the accumulation I know that for the longest release time the Numeric Count of events is 29. I would now wish to identify the first release time whose cumulative events is greater than 90%