https://communities.sas.com/t5/SAS-Visual-Analytics/YoY-QoQ-MoM-for-attrition/m-p/695110#M14382 <P>Hello&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/350324">@Shivraj93</a>&nbsp;</P> <P>&nbsp;</P> <P>Firstly you need to have appropriate Category data available. For example for QoQ you need to have a date(time) variable that has <EM>Quarter</EM> format.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 297px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51192i04E754A4250F1DF5/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> <P>&nbsp;</P> <P>Secondly you need to create Aggregated Measure for QoQ attrition. The easiest way to achieve this is by hovering over <FONT face="courier new,courier">Attrition</FONT> &gt; Click right-mouse-button &gt; New calculation... &gt; Type = Difference from previous period, Date = Quarter.</P> <P>&nbsp;</P> <P>Best regards,</P> <P>Petri</P> Thu, 29 Oct 2020 07:39:59 GMT PetriRoine 2020-10-29T07:39:59Z https://communities.sas.com/t5/SAS-Visual-Analytics/YoY-QoQ-MoM-for-attrition/m-p/694945#M14378 <DIV>How do I effectively show QoQ difference in SAS VA?</DIV><DIV>If I want to show the increase or decrease in attrition.</DIV><DIV>TIA <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></DIV> Wed, 28 Oct 2020 16:50:28 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/YoY-QoQ-MoM-for-attrition/m-p/694945#M14378 Shivraj93 2020-10-28T16:50:28Z https://communities.sas.com/t5/SAS-Visual-Analytics/YoY-QoQ-MoM-for-attrition/m-p/695110#M14382 <P>Hello&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/350324">@Shivraj93</a>&nbsp;</P> <P>&nbsp;</P> <P>Firstly you need to have appropriate Category data available. For example for QoQ you need to have a date(time) variable that has <EM>Quarter</EM> format.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 297px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/51192i04E754A4250F1DF5/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> <P>&nbsp;</P> <P>Secondly you need to create Aggregated Measure for QoQ attrition. The easiest way to achieve this is by hovering over <FONT face="courier new,courier">Attrition</FONT> &gt; Click right-mouse-button &gt; New calculation... &gt; Type = Difference from previous period, Date = Quarter.</P> <P>&nbsp;</P> <P>Best regards,</P> <P>Petri</P> Thu, 29 Oct 2020 07:39:59 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/YoY-QoQ-MoM-for-attrition/m-p/695110#M14382 PetriRoine 2020-10-29T07:39:59Z