This is the third blog in my series on how to build an analytic application in just 30 minutes using Logi Info. We already talked about how to connect your data source and add interactive visualizations to your dashboard. Now, I’m going to dig deeper and show you how to apply filters to your visualizations using the Analysis Filter element.
We can apply filters based on the different fields available through a query. Instead of building every conceivable type of filter based on the data types and different fields you may use, or defining each filter meticulously, we can simply use an Element in Logi called the Analysis Filter. This gives us the maximum level of filter capabilities with minimal developer effort.
Step 1: For each Panel, click the panel parameter element, and select “Just add Dashboard Panel Parameters Element.”
Step 2: Under General Elements, select Analysis Filter. It will require an ID. Name it suitably.
Step 3: Associate your Analysis Filter with the visualization by selecting Data Layer under each Panel, then selecting Analysis Filter Insert.
Step 4: Connect the Analysis Filter by typing in the ID you made in Step 2.
Now that the association is set, let’s specify what columns we are able to filter with.
Step 5: Select Analysis Filter Column and select Run a Wizard to add the Analysis Filter Column Element.
The wizard will automatically recognize what columns are available within the data set.
Step 6: Choose the filters you want to display.
Step 7: Go to the dashboard, select the Edit wheel of the visualization you just modified, and see all of the new filters.
Good news! To filter the remaining visualizations, we can simply copy and paste our Panel Parameters instead of repeating the previous steps.
Step 8: Copy and paste the Panel Parameters into the remaining panels.
Step 9: Each new Analysis Filter will need a unique ID, so change each one in the specified box.
Step 10: Associate each new Analysis Filter ID with its visualization, as directed in Steps 3-4.
If you are not using the same query as before, run the column Wizard again to identify the appropriate data needed for the filters, as we did in Step 5.
What if your users ask for a self-service environment where they can create their own content and visualizations? Check back next week for the final tutorial in this series, where I’ll teach you how to deliver self-service functionality using the Logi Analysis Grid element.
To see these tips and tricks in action, watch our webinar: How to Build an Analytics Application in 30 Minutes.
To learn more about creating an analytic application using Logi Info, read our previous blogs in this tutorial series:
- Overview: How to Build An Analytic Application in 30 Minutes
- How to Add Interactive Visualizations to the Dashboard