Mission 9 - Core Supplier Insights

Estimated time for completing this mission: 20 mins

​

Learning Objective

Understanding how to perform SQL like operations done purely in LOGIBLOX and create informative charts with data acquired.

Scenario

Now that you know the general concepts behind creating logics, you can go on and try to build a more complex logic that will display suppliers and their corresponding spending in a bar chart!

BLOX used in this mission:

• Basics/Start
• MyData/data_with_suppliers
• Database/View
• Charts/Bar Chart
• Basics/Display

Data

In this mission we will use the prepared dataset from the previous section.

If you could not create it, here is a link for the dataset data_with_suppliers.xlsx

​

Steps

Please refer to the Navigation Guide to perform the steps below

1. In the Flow builder, drag-and-drop all the necessary BLOX listed above
2. Connect the BLOX in sequence: "Start" → "MyData" → "View" → "Bar Chart" → "Display"
3. In the "MyData" BLOX settings, configure grouping by setting the "Group By" column to "Supplier". Then click the + button after "Aggregation", select "all" in the first dropdown and "sum" in the second dropdown
4. In the "MyData" BLOX settings, configure "Sort By" by specifying "Amount" as the sorting column
5. In the "View" BLOX settings, specify the columns to extract: "Supplier" and "Amount"
6. In the "Bar Chart" BLOX settings, set the axis: X - "Supplier" and Y - "Amount"
7. In the "Bar Chart" BLOX settings, set "Chart Orientation" to "vertical", "Tilt Axis Tick" to "Yes", and label the X and Y axes as "Supplier" and "Amount" respectively
8. Press the play button on "Start" BLOX to see the results in "Display" BLOX ​ ​ ​

​

Results and Summary

​ You can now easily analyze the spending done on each of the suppliers. ​

Well done! Now lets move on to the next mission!