Forum Discussion
Comparing historical average to current week average
Hi zallebban,
Please share a dummy sample of the original data. Because the sample you post doesn't contain the date column. Besides, there seems no such visual. How about the Line and clustered column visual?
Best Regards,
Dale
Dale, I think that visual would work.
This should do it. My post preview is showing the empty QC columns, but they are disappearing when I post. For demonstration purposes, feel free to reduce the number of quality attribute columns (prefixed by "QC") to make things easier. If necessary, I can send an Excel export if you provide an email address. Thanks.
Zayd
Date InitiatedName of CommuniquéQuality ScoreQC: Aligns w/TemplateQC: ClarityQC: CohesionQC: CompletenessQC: ConsistencyQC: ContentQC: DateQC: Draft LabelQC: FormattingQC: Spelling/Grammar
7/14/17 Communiqué 1 83 Yes Yes No Yes Yes Yes 7/20/17 Communiqué 2 50 Yes No No Yes Yes No 7/25/17 Communiqué 3 17 No No No No Yes No 7/26/17 Communiqué 4 100 Yes Yes Yes Yes Yes Yes 7/26/17 Communiqué 5 67 Yes Yes Yes Yes No No 7/27/17 Communiqué 6 67 Yes Yes No Yes Yes No 7/31/17 Communiqué 7 67 Yes Yes No Yes No Yes 8/8/17 Communiqué 8 100 Yes Yes Yes Yes Yes Yes 8/20/17 Communiqué 9 83 Yes Yes Yes Yes Yes No 8/22/17 Communiqué 10 83 Yes Yes Yes No Yes Yes 8/30/17 Communiqué 11 100 Yes Yes Yes Yes Yes Yes 9/14/17 Communiqué 12 100 Yes Yes Yes Yes Yes Yes 9/14/17 Communiqué 13 67 No Yes Yes No Yes Yes 9/19/17 Communiqué 14 33 No No Yes No No Yes 9/26/17 Communiqué 15 100 Yes Yes Yes Yes Yes Yes 10/9/17 Communiqué 16 10/12/17 Communiqué 17 83 Yes Yes No Yes Yes Yes 10/17/17 Communiqué 18 67 Yes Yes No No Yes Yes 10/19/17 Communiqué 19 83 Yes Yes Yes No Yes Yes 11/14/17 Communiqué 20 50 No Yes No No Yes Yes 11/27/17 Communiqué 21 100 Yes Yes Yes Yes Yes Yes 1/6/18 Communiqué 22 83 Yes Yes No Yes Yes Yes 1/8/18 Communiqué 23 67 Yes Yes No No Yes Yes 1/12/18 Communiqué 24 67 No Yes Yes No Yes Yes 1/22/18 Communiqué 25 2/6/18 Communiqué 26 100 Yes Yes Yes Yes Yes Yes 2/8/18 Communiqué 27 100 Yes Yes Yes Yes Yes Yes 2/19/18 Communiqué 28 100 Yes Yes Yes Yes Yes Yes 2/27/18 Communiqué 29 100 Yes Yes Yes Yes Yes Yes 2/27/18 Communiqué 30 100 Yes Yes Yes Yes Yes Yes 3/5/18 Communiqué 31 100 Yes Yes Yes Yes Yes Yes 3/6/18 Communiqué 32 67 Yes Yes No No Yes Yes 3/13/18 Communiqué 33 83 Yes Yes No Yes Yes Yes 4/2/18 Communiqué 34 100 Yes Yes Yes Yes Yes Yes
