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/Table
- Database/Group By
- Database/Make Unique
- Charts/Line Chart
- Basics/Start
App BLOX
- Chart
- Panel
- 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 Module4 folder
- In Module4 create a new app named Smart Search
- Include all the BLOX which are mentioned in the description above as App BLOX
- 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 make, set the the "Auto run" to "Yes" such that the lookahead values are initialized
- For the "Group By" logic, specify the column "ORDERDATE" and the aggregation as "sum"
- 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
