TC Running Total?

reference line band or box

TC-Running-Total?
Ans:
1. Drag Date field into Columns and right click on it and select more option in that select date part as MONTH?DAY?YEAR option then click on apply then click on ok.
2. Create a calculation for Daily Close Position.
Name the calculation as Daily Close Position.
Calculation is :
WINDOW_SUM(SUM([New Cases]),-INDEX(),0)+
WINDOW_SUM(SUM([Re Opened]),-INDEX(),0)-
WINDOW_SUM(SUM([Closed]),-INDEX(),0).
3. Create a calculation for Daily Open Position,
Name the calculation as Daily Open Position,
Calculation is :
LOOKUP([Daily Close Position],-1)
4. Now drag the Daily Open Position into rows.
5. Now drag Measure Names i9nto filter and select the fields as shown below.

filter measure

6. Now drag Measure names into color shelf.
7. Drag Daily Close Position into text shelf.
8. Drag Daily Open Position into Details shelf.
9. Drag New Cases into details shelf.
10. Drag Re Opened into details shelf.
11. Drag New Change for Day into details.
12. Now go to Analytics Window and Drag reference line into visualization area and place it into Pane. Then select the fields as shown below.
edit reference line
13. Now Drag Distribution band into visualization area and place it into Pane level. And select the fields as shown below.

band or box

14. Again drag Distribution band into visualization area and place it into pane level. And select the fields as shown below

reference line band or box

15. The visualization looks like below,

TC Running Total

Leave a Reply

Your email address will not be published. Required fields are marked *