{"id":26444,"date":"2023-04-26T09:33:05","date_gmt":"2023-04-26T09:33:05","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=26444"},"modified":"2023-04-27T04:25:53","modified_gmt":"2023-04-27T04:25:53","slug":"creation-of-bar-charts-using-graphical-query-tool-and-adding-these-query-tool-to-dashboard","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/04\/26\/creation-of-bar-charts-using-graphical-query-tool-and-adding-these-query-tool-to-dashboard\/","title":{"rendered":"Creation of Bar Charts and adding it to Dashboard"},"content":{"rendered":"\n

In industries Dashboard plays a very important role for users which provides summarized data of organizations, transactions and masters. Sage X3 <\/a>has features to show dashboard data into graphical charts like bar chart, Pie chart, line chart & different types of chart. One of our clients has a requirement to represent the data on the dashboard in bar chart format using a graphical query tool.
We have achieved these requirements by following the below steps.<\/p>\n\n\n\n

New stuff:<\/strong> Exporting Real Time \u2013 SEI Data Models Using Excel Add-In<\/a><\/p>\n\n\n\n

  1. Open Graphical Query Tool screen through by these path Setup Module –> Reports click on Graphical Query Tool as highlighted in below screenshot:<\/li><\/ol>\n\n\n\n
    \"Graphical<\/a><\/center>\n
    Graphical Query Tool<\/center><\/font>\n\n\n\n

    2. Once clicked, the Below screen will be opened which is the Graphical Query Tool development platform.<\/p>\n\n\n\n

    \"Graphical<\/a><\/center>\n
    Graphical Query Tool<\/center><\/font>\n\n\n\n

    To Create a new graph, click on the + button as highlighted in the above screenshot and then add the code \u201cZSALES1\u201d(can be as per your requirement)\uf86a Provide the description in the description field.<\/p>\n\n\n\n

    3. Once the Description is provided proceed further with the addition of Tables by clicking on below mentioned icon:<\/p>\n\n\n\n

    \"Adding<\/a><\/center>\n
    Adding table or views<\/center><\/font>\n\n\n\n

    4. Once the above-highlighted icon is clicked, a pop window will open for the selection of the table. From which you can add the table as per your requirement.<\/p>\n\n\n\n

    \"Selection<\/a><\/center>\n
    Selection window for table or view<\/center><\/font>\n\n\n\n

    5. Once the table is inserted, will proceed further with the addition of the fields, for this double click on the fields from the added tables, accordingly, fields will be added as shown in below screenshot<\/p>\n\n\n\n

    \"Columns<\/a><\/center>\n
    Columns from the table<\/center><\/font>\n\n\n\n

    6. To group the data as per your requirement, drag the field slightly towards the up side which will group the data as per the fields as highlighted in below screenshot:<\/p>\n\n\n\n

    \"Grouping<\/a><\/center>\n
    Grouping data<\/center><\/font>\n\n\n\n

    7. To sort the data in particular fields wise, click on the below-highlighted icon which will sort the data in ascending and descending order whenever a query is run:<\/p>\n\n\n\n

    \"Sorting<\/a><\/center>\n
    Sorting data in ascending or descending order<\/center><\/font>\n\n\n\n

    8. To represent the numeric field as a candle in the graph, click on the below-highlighted icon according to which column is ticked, candle will be inserted for the particular field in the graph:<\/p>\n\n\n\n

    \"Adding<\/a><\/center>\n
    Adding column to chart<\/center><\/font>\n\n\n\n

    9. To filter the table data for the specific condition we can use the selection criteria functionality where we can define the conditions according to which data in the output will be filtered. For example, to show only open sales orders below the highlighted condition is created.<\/p>\n\n\n\n

    \"Selection<\/a><\/center>\n
    Selection criteria<\/center><\/font>\n\n\n\n

    10. Graphical configuration:<\/p>\n\n\n\n

    \"Graphical<\/a><\/center>\n
    Graphical configuration<\/center><\/font>\n\n\n\n

    To configure the visual presentation of the graphical query tool above mentioned graph section is used:
    i) Representation: Here, we can define whether the user wants to see the graph with a chart or only the graphical representation of the created query.
    ii) Graphical Position: Here, we can define the position of the graph whether it should be above the chart or below the chart on the dashboard.<\/p>\n\n\n\n

    Type:<\/strong> This field is used once there is more than one numeric value in the grid that is likely to be presented in a graphical form. It can take one of two values: Single graph: in this case, only one column of values is displayed at a time (a selector is used to make to choice)\/
    Multi-graph: <\/strong>in this case, all the columns are displayed, combined according to the parameter defined by the parameter\u00a0Representation.
    iii) Default Graph: To choose the graphical representation in the form of Bars, Lines, and Areas accordingly the system will generate the graph.<\/p>\n\n\n\n

    11. Once the query is configured and created next step is to validate the query by clicking on the below-highlighted \u201cvalidate\u201d button:<\/p>\n\n\n\n

    \"Validate<\/a><\/center>\n
    Validate Graphical Query Tool<\/center><\/font>\n\n\n\n

    12. After the Validation process, To execute the query click on the run button:<\/p>\n\n\n\n

    \"Execute<\/a><\/center>\n
    Execute query tool<\/center><\/font>\n\n\n\n

    13. You can confirm the output as shown in below image before adding to the dashboard:<\/p>\n\n\n\n

    \"Output<\/a><\/center>\n
    Output of query tool<\/center><\/font>\n\n\n\n

    14. Now, to add the created graph on the dashboard below procedure should be followed:
    Go to the Administration module\uf86a click on Menu Items as shown in below highlighted image:<\/p>\n\n\n\n

    \"Administration<\/a><\/center>\n
    Administration Menu items<\/center><\/font>\n\n\n\n

    15. Create a new Menu Item by clicking on \u201cnew Menu Item\u201d button as shown in below image:<\/p>\n\n\n\n

    \"Img<\/a><\/center>\n
    Img 15- Create Menu Item<\/center><\/font>\n\n\n\n

    16. Add the information as Code, Title, Description select Link Type as \u201cQuery\u201d, select the X3 ERP application in the application field and enter the query name which will be the graphical query tool code.<\/p>\n\n\n\n

    \"Menu<\/a><\/center>\n
    Menu Item Configuration<\/center><\/font>\n\n\n\n

    17. Once the menu item is created go to the dashboard and click on \u201c+new\u201d button as highlighted button in below image:<\/p>\n\n\n\n

    \"Create<\/a><\/center>\n
    Create new dashboard<\/center><\/font>\n\n\n\n

    18. This will open the below pop-up In which define the page name and title for the dashboard.<\/p>\n\n\n\n

    \"Assigning<\/a><\/center>\n
    Assigning code & description to new dasboard<\/center><\/font>\n\n\n\n

    19. After clicking OK on the above screen, the below screen will get pop up in which select the Endpoint as LIVE, and in the browse category select Queries as highlighted in below image:<\/p>\n\n\n\n

    \"Select<\/a><\/center>\n
    Select browse category<\/center><\/font>\n\n\n\n

    20. Here, select the query name by navigating to the specific module\uf86a categories\uf86a gadgets\u201d<\/p>\n\n\n\n

    \"Adding<\/a><\/center>\n
    Adding menu item to gadgets<\/center><\/font>\n\n\n\n

    21. Final output will be represent as shown in below image:<\/p>\n\n\n\n

    \"Dashboard<\/a><\/center>\n
    Dashboard Output<\/center><\/font>\n\n\n\n

    This way we can create a graphical query tool query with a bar chart and adding the same to the dashboard.<\/p>\n\n\n\n

    About Us<\/strong><\/h2>\n\n\n\n

    Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

    Greytrix has some unique integration solutions developed for Sage CRM<\/a> with Sage ERPs namely Sage X3<\/a>, Sage Intacct<\/a>, Sage 100<\/a>, Sage 500<\/a>, and Sage 300<\/a>. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.<\/p>\n\n\n\n

    Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 \u2013 Sage CRM integration listed on Sage Marketplace<\/a> and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace<\/a>. The GUMU™ Cloud framework<\/a> by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n

    For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In industries Dashboard plays a very important role for users which provides summarized data of organizations, transactions and masters. Sage X3 has features to show dashboard data into graphical charts like bar chart, Pie chart, line chart & different types of chart. One of our clients has a requirement to represent the data on the\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[477,496,913,3740,1822,1977],"class_list":["post-26444","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-customer","tag-dashboard","tag-graphical-query-tool","tag-open-sales-order","tag-sage-x3","tag-sales"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=26444"}],"version-history":[{"count":35,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26444\/revisions"}],"predecessor-version":[{"id":26540,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/26444\/revisions\/26540"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=26444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=26444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=26444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}