AUD PLATFORM EN
페이지 트리

버전 비교

이전 버전 3

changes.mady.by.user guide

에 저장

비교대상

새 버전 4

changes.mady.by.user guide

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.
댓글: V2 Hour 수식 변경

...

Target Screen


참고사항
titleTemplate Report Information

Download Practice Template

To study the practice example above, use the following report by saving it with a new name.

  • How to Use the Template:
    1. Launch the report from the portal.
      Template Path : [PPDM] > [Templates] > [1. Reporting] > [Dashboards] > Template_Monthly Sales Analysis

    2. Click the Save As button in the top right to save it to your working folder.

    3. Run the saved report.

    4. Click the Edit Report button in the top right to launch the Designer window.


...

  1. Establish hourly sales trends in V2, and aggregate data using SUMIFS function and get time-dimension using Data Derivation Method.
  2. Navigate tot he T3 data sheet and parse the time items using a function to enable SUMIF aggregation. 
    Time Derived Function  =IF(C2="After 22:00", "22:00", LEFT(C2,2)&" hour:00")


  3. Connect to the T3 data sheet using SUMIFS int he V2 sheet. 


  4. Assign the _D_ reserved keyword to generate the hourly sales visualization chart.  _D_예약어 ☜ Refer to the detailed guide


  5. Apply Conditional Formatting to the product-specific sales information to add visual depth, ensuring higher vales are displayed in darker colors.


  6. Format all cells based on their values > 2-Color Scale > Select colors and click OK.

...