# Reporting with Tableau

## 📋 ngSurvey template

<figure><img src="/files/QD2eEmQF3vW0Rd80adUc" alt=""><figcaption></figcaption></figure>

This is the template with questions we have used to create a report.

{% hint style="info" %}
The respondent's answers that are shown here are not real and were generated particularly for this walkthough.
{% endhint %}

## 📈 ngSurvey reporting example

Here you can see the data report by each question from the template we used.

<figure><img src="/files/R329VOY88MCe8qkh6eJK" alt=""><figcaption></figcaption></figure>

## 📊 Tableau cross-data reporting

In this visualization, we will focus on the survey question: "**How would you rate your overall satisfaction with our service?**" This question is represented by the variable '**General Satisfaction**' in the dataset. Specifically, we will analyze the average satisfaction based on the following parameters: date, likelihood to recommend, age group, client tenure, and client expectations.

## 📈 Start with simple visualization

In Tableau, visualizations are created using sheets, which are then assembled into a dashboard. The uploaded data is automatically categorized into Dimensions (blue) and Measures (green).&#x20;

<figure><img src="/files/m665oIYh1Zb6nTSvUYiL" alt="" width="375"><figcaption></figcaption></figure>

1. **Create Sheets for Each Visualization:**
   * Each sheet will become an element in the final dashboard.
2. **Graphic by Date:**
   * Drag the **Date** dimension to **Columns**.
   * Drag the **General Satisfaction** measure to **Rows**
3. **Adjust Variables:**
   * Tableau initially displays data by Year. To change this to Month and Day, click the Date field in Columns, then select the desired date level from the settings.
   * By default, General Satisfaction will be shown as SUM. Change this to Average by clicking the field in Rows and selecting Average from the settings.
4. **Line Graph:**
   * Tableau automatically selects a line graph for this data. To customize the line style, go to the Marks box, click on Path, and choose your preferred style.

## Assembling the Dashboard

<figure><img src="/files/CPQLZ5AkbhWLiOIo30QA" alt=""><figcaption></figcaption></figure>

Once all the **Sheets** are ready, they can be **dragged and dropped** from the left menu to assemble them in the dashboard.

<figure><img src="/files/aMRel5fR34CQk8myUoKf" alt="" width="375"><figcaption></figcaption></figure>

To avoid elements moving or overlapping when changing the screen size, use **horizontal or vertical containers** from the **left menu** to place objects inside:

* **Drag and drop a container** from the left menu onto the dashboard.
* Ensure each element is in **floating mode** to move it into containers.
* Select the visual element, **hold Shift**, and drag it into the container. Repeat for each element.
* In the container's right menu, **select the horizontal container**, then **resize** it as needed.
* Use several horizontal containers to organize objects horizontally, and place these containers into a vertical container.

<figure><img src="/files/BUvcM6dZSVZPIv6AkppH" alt=""><figcaption></figcaption></figure>

Change the dashboard size in the left menu to find the best view for your data.

## 📰Walkthrough Dashboard result

After creating and organizing all the visual elements, we have developed a detailed dashboard to visualize the General Satisfaction.

<figure><img src="/files/77Ca9LDkJZKlooPI2rOM" alt=""><figcaption></figcaption></figure>

This detailed analysis demonstrates how average of general satisfaction varies across these parameters, providing insights into clients attitudes towards the service.

<figure><img src="/files/BmbXOb5ssSO8TaDhmG6A" alt=""><figcaption></figcaption></figure>

As we can see, loyal clients who have been receiving service for more than two years and whose expectations are met exhibit significantly higher satisfaction scores. Notably, these clients are either very young (18 years old or younger) or adults aged 45 to 64, with an average satisfaction score of 4.75 out of 5. This is in contrast to the overall average satisfaction score of 3.03 for the entire dataset. Some of these clients have the potential to become strong supporters of the company.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ngsurvey.com/walkthroughs/tableau-integration/link-data-to-tableau/reporting-with-tableau.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.