현황판 구축 및 사용자 지정¶
In addition to consulting standard dashboards, users with the appropriate access rights can build custom dashboards from scratch or customize existing dashboards to respond to specific business needs.
현황판 구축하기¶
In its most simple terms, building a dashboard involves inserting Odoo data into a spreadsheet then converting that spreadsheet into a dashboard.
However, to build a dashboard that delivers relevant and valuable insights, it is important to consider the process in terms of three key stages: preparation, data insertion and manipulation, and data visualization.
준비¶
이 단계에서는:
defining the purpose of the dashboard, in other words, the business questions it needs to answer, and deciding what data would answer those questions;
determining where to find the relevant Odoo data and deciding which type of view (i.e., list, pivot table, or chart) is most suited for the data analysis needed;
preparing the Odoo data by refining the views to focus on the most relevant information, e.g., by using search filters, by making only certain list fields visible, or by deciding which dimensions and measures a pivot table should use;
기타 모든 정보를 수집하여 현황판에서 지원합니다.
데이터 삽입 및 가공¶
이 단계에서는:
inserting the prepared lists, pivot tables or charts into the spreadsheet you will use to build your dashboard;
manipulating the data, if needed, to be able to draw the necessary insights. This may involve performing calculations or creating custom metrics using standard or Odoo-specific functions and formulas, referencing data from various sources within the spreadsheet, or converting static pivot tables to dynamic pivot tables.
데이터 시각화¶
이 단계에서는:
스프레드시트의 첫 번째 시트(즉, 현황판의 프론트엔드 역할을 할 시트)에는 데이터를 명확하고 시각적이며 의미 있는 방식으로 제시하여 쉽게 해석할 수 있게 하는 것이 중요합니다. 구체적으로는, 표와 그래프와 같은 요소의 레이아웃 및 순서를 정하고, 명확하고 자세한 제목, 텍스트 서식 및 색상, 적절한 그래프 유형 선택, 조건부 서식을 이용한 특정 데이터에 대한 시각적 강조 등 사용자를 안내할 수 있는 도구와 기법을 활용하도록 합니다.
inserting clickable links, if relevant, to provide access to Odoo menu items, URLs, or other sheets within the same spreadsheet if these should also be accessible from the front end of your dashboard;
creating global filters to allow users to tailor the view to their needs;
converting the spreadsheet into a dashboard, determining whether to add the dashboard to an existing or new dashboard section, and managing access rights to the dashboard.
팁
Use standard dashboards as inspiration for how to best present and visualize data. For example, for charts, open the underlying spreadsheet of a standard dashboard, hover over a chart and click the (menu) icon, then Edit to see the chart properties on the right side of the screen.
The possibility to link to other sheets within the same spreadsheet allows the creation of a multi-page dashboard, with users able to navigate between pages thanks to clickable links. Global filters apply across all pages of a dashboard.
현황판 사용자 지정¶
현황판은 해당 현황판의 기본 스프레드시트를 편집하여 맞춤형으로 사용할 수 있습니다.
중요
When customizing a standard dashboard, it is highly recommended to duplicate the dashboard and make any changes on the underlying spreadsheet of the duplicated version. Standard dashboards are reinstalled at each Odoo version upgrade, meaning any customizations on the original version are lost.
기본 스프레드시트를 엽니다¶
현황판의 기본 스프레드시트를 열려면:
현황판 앱에서 으로 이동합니다.
Open the relevant dashboard section, then, on the line of the relevant dashboard, click Edit.
팁
Users who do not have the appropriate access rights to customize a dashboard can still access a read-only version of the dashboard’s underlying spreadsheet.
To temporarily unpublish a dashboard while you make changes, disable Is Published before editing the dashboard, making note to republish it when the customization has been finalized.
With developer mode activated, click on the (Edit) icon beside the name of a dashboard in the left panel to open its underlying spreadsheet.
The spreadsheet that opens typically consists of at least two sheets:
The first sheet always serves as the front end of your dashboard, and contains the tables and charts used to structure and visualize the data.
The second and any subsequent sheets typically contain data used for the calculation of key metrics shown on the first sheet.
참고
The data sources that maintain the connection between the spreadsheet and the relevant models in your database can be viewed by clicking on the spreadsheet’s menu bar. These data sources are identified by their respective (pivot table), (list) or (chart) icon, followed by their ID and name, e.g., (#1) Sales Analysis by Product.
For standard dashboards, while the data sources are still active and visible in the menu, the corresponding lists and pivot tables have been removed from the spreadsheet for better performance and a neater appearance.
현황판 복제¶
현황판을 복제하려면:
현황판 앱에서 으로 이동합니다.
Open the relevant dashboard section, then, on the line of the dashboard you want to duplicate, click Edit.
In the spreadsheet that opens, click .
Rename the duplicated dashboard by clicking the name of the spreadsheet at the top left of the screen and editing as needed.
팁
To return to the overview of the dashboard section, click the name of the original dashboard at the top left of the page, then the name of the dashboard section.
After duplicating a dashboard, delete the original dashboard by clicking the (trash) icon or rename it by clicking on the name then editing it.
현황판 요소 추가, 편집 또는 제거하기¶
다음과 같은 다양한 방식으로 현황판을 맞춤 설정합니다:
adding new tables and charts based on previously inserted or newly inserted Odoo data. This requires a similar approach to building a dashboard from scratch;
adding new global filters or editing or deleting existing ones;
adding or editing clickable links to Odoo menus, URLs, or to other sheets within the same spreadsheet.
팁
Dashboard elements that are no longer needed can be deleted from the spreadsheet. If, after deleting a dashboard element, a data source is no longer being used in the spreadsheet, this is indicated by a (warning) icon in the Data menu.
신규 Odoo 데이터 삽입하기¶
Inserting new Odoo data into a dashboard’s underlying spreadsheet requires starting from the relevant Odoo view. To do so:
With the relevant list view, pivot view or graph view open in your database, proceed as follows:
For a list view, click the (Actions) icon beside the name of the view, then Spreadsheet –> .
For a pivot or graph view, click Insert in Spreadsheet at the top left of the view.
In the window that opens, edit the name if needed. For a list, edit the number of records, i.e., rows to be inserted, if needed.
Click the Dashboards tab then select in which dashboard the list, pivot table, or chart should be inserted.
A list or pivot table is inserted into a new sheet in the dashboard’s underlying spreadsheet; a chart is inserted on the first sheet of the spreadsheet.