Mission 5 - Smart Search
Estimated time for completing this mission: 20 mins
Learning Objective
Using lookahead to search in your data set is extremely convenient and fast. In this mission we will show how to implement this with LOGIBLOX.
BLOX used in this mission:
Logic BLOX
- MyData/FinalData
- Database/Make Unique
- Charts/Line Chart
- Basics/Start
App Templates
- Chart
- Button
- Lookahead Input Field
- Label
Data
The same data set will be used as for the previous exercise. In case you do not have the data set you can download it here: FinalData.xlsx
Steps
Please refer to the Navigation Guide to perform the steps below
App Designer:
Smart Search
- Import dataset from Data section to Module5 folder
- In Module5 create a new app named Smart Search
- Include all the BLOX which are mentioned in the description above as App Templates
- Once the required BLOX are in, create the layout of the map using the image shown above
- Create two logics according to the logic views from above (Note that both logics should be created to the same page).
- In the chart logic, for the input of "MyData" BLOX, Search needs to be specified as an operation, and the filter of "PRODUCTLINE" should be set to Equal.
- For the "Start" BLOX, set the the "Auto run" to "Yes" such that the lookahead values are initialized
- In the "MyData" BLOX settings, configure group-by by setting the "Group By" column to "ORDERDATE". Then click the + button after "Aggregation", select "all" in the first dropdown and "Sum" in the second dropdown
- In the "MyData" BLOX settings, filter the "PRODUCTLINE" column by selecting "Equal" as the operation. Click the eye icon next to it to make the operand connectable.
- Next, in the "Line Chart" BLOX, specify X as "ORDERDATE" and Y as "SALES" and tick two first options to yes
- Finally, run the app and type in a product to see different results (such as "ship" or "vintage")
Results and Summary
