Thanks for putting your time and effort in solving my problem.
Although what i wish to to achieve is a bit different.
first of all i don't want to plot running total of of the counts. I want to plot the hour v/s count of variable.
Secondly i want the 98 %ile line perpendicular to hour dimension axis.
in your screenshot it should be at number 5 but exact perpendicular to the line that you have plotted.
Sorry for the delay...was quite busy. I think I got it working..unless ofcourse I misunderstood your requirements!
Attached is the screenshot of the output and here are the steps:
a. Create a calc field called Total Variable with the following formula (note the brace brackets which are required for it to be a LOD calc:
b. Create a calc field called Mark with teh following formula:
If RUNNING_SUM(sum([Variable])) > sum([Total Variable])*0.98
AND lookup(RUNNING_SUM(sum([Variable])),-1) < sum([Total Variable])*0.98
then sum([Total Variable])
c. Create a dual axis chart (refer to my screenshot to see how I have placed the fields on row, column, color and label fields to recreate the viz
Hope this helps!
Perpendicular line test.png 35.3 KB