![]() ![]() (IF statements are calculated until a condition is true, so the second segment only needs to specify the upper limit.) The second segment’s cutoff is <=8 (encompassing weeks 5–8), and the remaining weeks (9-13) are captured in the ELSE portion. The first segment's cutoff is <=4 for the first four weeks (1-4). In the 4-4-5 Segment calculation, the cutoffs <=4 and <=8 come from the 4-4-5 pattern. The resulting viz now has each quarter broken down into three segments. From the data pane, drag the 4-4-5 Segment calculated field to the Rows shelf.The values 1, 2, 3 are labels for the three segments and can be replaced with any value you choose. Name the calculated field 4-4-5 Segment. ![]() Step 3: Create the 4-4-5 calendar calculation ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |