How to create pivot tables in Fibotalk
Sometimes there can come a situation where just a mere listing of users is not enough in the cohort analytics, and we want to do a deeper level analysis. That’s where pivot tables come into play. Fibotalk now provides you the ability to create pivot tables in user cohorts.
What is a pivot table?
A pivot table is just like any other table with the only difference being that its elements are grouped on a certain parameter. For example, in Fibotalk we can create a pivot table for users on parameters like browser, source referrer, country, etc.
Creating a pivot table in the Fibotalk application is very intuitive and simple and can be done with the below steps.
- On the cohort screen, you will find a section in the filters panel which allows you to pivot the records on a particular field. You can choose from various options of parameters on which you want to create the pivot table.
- Submit the selection after choosing a parameter to create a pivot table and then a pivot table will be created.
- Save the pivot table and then you can find the exact same pivot table in the “Pivot tables” section of the side menu.
After you have saved the pivot table you can find the same in the “Pivot tables” section in the side menu. A very interesting fact about these saved pitot tables is they already have the filters applied from their parent cohort from which the table was initially created.
You can modify the pre-applied filters and save a whole new pivot table from that.