.. image:: /_images/icons/app_simlytiks.png :width: 5% :align: right :target: index.html .. |ViewData| image:: /_images/icons/icon_ViewData.png :width: 4% :target: ViewingData.html .. _View: ######################################## |ViewData| Viewing & Organizing Data ######################################## For this section, we'll be going over how to view our data after we import it into Simlytiks .. thumbnail:: /_images/Images/Splash/ViewingData_Intro.gif :title: Viewing Fruit Dataset Data Columns .. centered:: **Viewing Fruit Dataset Data Columns** | ******************* |table| Our Dataset ******************* For this tutorial, we'll be exploring this simple dataset on fruits. +-------------+-----------+----------------+-----------------------+------------+ | Climate | Fruit | Type | Location | Percentage | +=============+===========+================+=======================+============+ | temperate | cherry | Tart | Michigan, USA | 0.75 | +-------------+-----------+----------------+-----------------------+------------+ | tropical | banana | Plantain | Hawaii, USA | 0.3 | +-------------+-----------+----------------+-----------------------+------------+ | subtropical | orange | Navel | Florida, USA | 0.5 | +-------------+-----------+----------------+-----------------------+------------+ | temperate | apple | Gala | Washington State, USA | 0.24 | +-------------+-----------+----------------+-----------------------+------------+ | tropical | banana | Hawaii Apple | Hawaii, USA | 0.47 | +-------------+-----------+----------------+-----------------------+------------+ | subtropical | orange | Valencia | California, USA | 0.17 | +-------------+-----------+----------------+-----------------------+------------+ | temperate | blueberry | Highbush | Michigan, USA | 0.32 | +-------------+-----------+----------------+-----------------------+------------+ | temperate | grape | Flame Seedless | California, USA | 0.18 | +-------------+-----------+----------------+-----------------------+------------+ | temperate | apple | Red Delicious | Washington State, USA | 0.34 | +-------------+-----------+----------------+-----------------------+------------+ | tropical | banana | Cuban Red | Hawaii, USA | 0.8 | +-------------+-----------+----------------+-----------------------+------------+ Once we import our data, we can view it as a dataset on Simlytiks and organize it however we like. Initially, Simlytiks organizes the data into data columns (responses) and presents an overview table as the first page in the dashboard. ********************* |eye| Simlytiks Views ********************* Simlytiks interface can be viewed in three different ways: Modern, Classic and Slides. Modern View keeps the pages panel as tabs at the top of the page with just responses in the left-side panel; Classic contains them as a tree folder structure in the left-side panel above responses; while, Slides shows them as mini page previews in the left-side panel without responses shown by default. Modern View ============ .. thumbnail:: /_images/Images/ViewingData/Simlytiks_Overview_Modern.png :title: Modern View .. centered:: **Figure 1: Modern View** | 1. |eye| View: Change the user interface style. This is the Modern View. 2. |line-chart| Response Panel: This shows all our data columns. 3. |list| Overview Table: This is an overview table of all our data. Modern View also has the option to view all the responses in the dataset by clicking on play button. Here is a video showing how it works: .. video:: _static/movies/ModernViewResponsePlay.mp4 :width: 100% | | Classic View ============= .. thumbnail:: /_images/Images/ViewingData/Simlytiks_Overview_Classic.png :title: Classic View .. centered:: **Figure 2: Classic View** | 1. |eye| View: Change the user interface style. This is the Classic View. 2. |line-chart| Response Panel: This shows all our data columns. 3. |table| Overview Table: This is an overview table of all our data. Slides View ============ .. thumbnail:: /_images/Images/ViewingData/Simlytiks_Overview_Slides.png :title: Slides View .. centered:: **Figure 2: Slides View** | 1. |eye| View: Change the user interface style. This is the Slides View. 2. |line-chart| Response Panel: This shows all our data columns. 3. |table| Overview Table: This is an overview table of all our data. ********************** |table| Overview Table ********************** The initial overview table presents our full dataset with all its columns and rows, unless we have a large dataset with a lot of records. These bigger datasets will instead be presented in a summary view instead of a table as shown in the image below: .. thumbnail:: /_images/Images/ViewingData/Simlytiks_SummaryOverview.png :title: Summary Overview .. centered:: **Figure 4: Summary Overview** | We can change the view, download and customize our overview table. .. thumbnail:: /_images/Images/ViewingData/Simlytiks_OverviewTable.png :title: Overview Table .. centered:: **Figure 5: Overview Table** | 1. |eye| View Type: Change the visualization of the table to view the data in a different way. 2. |download| Download: Export the table via CSV, PPT, PNG, JSON, ZIP, text or copy it to clipboard. 3. |sliders| Customize: Change aspects such as font size and weight, and reorder columns. Check out this video showing how to work with the table. .. video:: _static/movies/OverviewTable.mp4 :width: 100% | | |file| Pages Full Screen ========================== Click on the full screen view option at the top of a page to get an expanded view of it. .. thumbnail:: /_images/Images/ViewingData/pagefullscreen.png :title: Overview Table .. centered:: **Figure 6: Overview Table** ********************** |columns| Data Columns ********************** Simlytiks finds data columns from the data source and organizes it into responses. The icon next to each data column indicates its value type. Read the :ref:`Value Types ` section to learn more about them. We can view data columns as charts by clicking on the curve icon that appears when hovering over it with our mouse as shown in the clip below. Once the window opens for viewing a response, we can navigate between all responses using the respected buttons at the top right. .. video:: _static/movies/ViewingResponses.mp4 :width: 100% | | NEW as of February 1, 2022: Responses sidebar has a context menu to preview and add bin columns in the responses list. .. thumbnail:: /_images/Images/ViewingData/ContextMenuSideBar.png :title: Responses Context Menu .. centered:: **Figure 7: Responses Context Menu** | We'll build our exploration by creating new pages and adding charts to them, using our data columns as chart inputs. Jump ahead to learn about :ref:`charts here ` and :ref:`pages here. ` Here is an example of two basic charts on a page for our dataset. .. thumbnail:: /_images/Images/ViewingData/Simlytiks_ViewingBasic.png :title: Basic Charts .. centered:: **Figure 8: Basic Charts** | ************************ |database| Data Options ************************ |filter| Filtering Data ======================= Global dataset filtering can be found at the top right corner of the page next to the settings button. You can also update specific filters under the Tools menu. .. thumbnail:: /_images/Images/ViewingData/GlobalFilters.png :title: Dataset Filtering .. centered:: **Figure 9: Dataset Filtering** |object-group| Grouping Data ============================= Under Tools -> Customize -> Groups, you can create and auto-create custom groups within a data column and specify colors for each. .. video:: _static/movies/CustomGroups.mp4 :width: 100% | | There is also an option to bin data under Tools > Data Operations. Just use the "Add Column By Binning" transformation to create your new binned data column. .. thumbnail:: /_images/Images/ViewingData/SimlytiksBinning.png :title: Add Column By Binning .. centered:: **Figure 10: Add Column By Binning** **************************** |wrench| Tools **************************** There are different tools available for organizing and editing the dataset. Dataset Settings ================== Settings under the Tools dropdown helps in configuring basics like layout, names, color schemes and page settings. .. thumbnail:: /_images/Images/ViewingData/datasetsettings.png :title: Dataset Settings .. centered:: **Figure 11: Dataset Settings** Objectives & Targets ===================== Under the Tools dropdown, choose Objectives & Targets to help trigger particular data for the dataset. .. thumbnail:: /_images/Images/ViewingData/ObjectivesTargets.png :title: Objectives & Targets .. centered:: **Figure 12: Objectives & Targets**