Hello- I have a data set that is a running total of time to an event (timeOUT) which is a percent from 0 to 100%. However, due to the number of days to each event, sometimes there will not be a value for all 101 timeOUT values that i want (see below)
teamNAME
gameDATE
timeOUT
totalPRESOLD
ticketDAYTOTAL
totalSOLD
tixSOLDPERDAY
vs. Lightning
10/10/2017 0:00
0%
10
10
1000
10
vs. Lightning
10/10/2017 0:00
5%
10
10
1000
10
vs. Lightning
10/10/2017 0:00
8%
10
25
1000
25
vs. Lightning
10/10/2017 0:00
12%
10
35
1000
35
vs. Lightning
10/10/2017 0:00
17%
10
83
1000
83
vs. Lightning
10/10/2017 0:00
20%
10
16
1000
16
vs. Lightning
10/10/2017 0:00
24%
10
12
1000
12
vs. Lightning
10/10/2017 0:00
29%
10
14
1000
14
Is there a way to create values (like 1%, 2% etc) that do not currently exist? What i'd like to end up with is this (not concerned with filling in values for totalPRESOLD, ticketDAYTOTAL or totalSOLD:
Pleas see the sample app provided. For reference, the chart shows 4 lines. The yellow line (avg(RunningTotal)) is the line I am trying to fix with the issues we have been discussing. the green line (=SalesTrend) is a test line that i built outside of the system manually. Once the duplication issues are no more, the yellow line should match that green line.
