Question 1

How do I make columns in my table expand and their titles fully visible?

Accepted Answer

Today, the table visualization can only be as wide as the available width on your screen. If you are on a small screen or if your query has many indicators and group bys, this can result in the columns being very narrow, compressing data and column headers.

Unticking ‘Fit Width’ in ‘Settings’ allows you to disable this behavior so that columns can be wider and bleed off the available screen width. You can then scroll horizontally to view all columns and data.

Question 2

How do I add my visualization to a dashboard?

Accepted Answer

To add your visualization to a dashboard, click on the ‘+Add to Dashboard’ button at the top right corner. A dialogue box opens. If you want to create a new dashboard and add the visualization to it, click ‘Create Dashboard.’ If you want to add the visualization to an existing dashboard, explore ‘My Dashboards’ or ‘Others Dashboards’ dropdowns to find the right dashboard. When done, click ‘Save’ to retain your changes.

See the ‘Dashboards’ section for more information about building, curating and administering dashboard resources.

Question 3

How do I select a time period (“Date Range”) filter for my query?

Accepted Answer

An additional possibility to restrict the scope of your analysis is to filter the data by time period. Adding a date filter allows you to pull data on all indicators from the time period you specify in the filter.

To select a time period for your analysis:

Go to the Analyze tool page.
Under the ‘Filters’ section, click on ‘Add+’ and then on ‘Date Range.’ This will add a date tag in your query form to customize.
Here you can choose either a custom date range or from a number of preset options including ‘this’ or ‘last’ week, month, quarter, or year as well as ‘all time’ and ‘Year to date.’ If you select “Custom” in the date range dropdown, then you will be able to filter to specific start and end dates by using the input calendars. You can also query ‘since’ a specific date.

Note: If you don’t apply a time filter to your analysis, by default all data available (‘all time’) in the platform will be added to your analysis. Also note that the date selections are “inclusive”; this means the days you include in the range will also be queried.

Question 4

How do I delete a custom calculation?

Accepted Answer

To delete a calculated indicator:

Go to ‘Calculations’ button at the top of your visualization
Click on the down arrow button on the calculated indicator you would like to edit
Click on ‘Delete calculation’ from the dropdown menu

Question 5

How do I create a stacked bar chart?

Accepted Answer

A stacked bar chart is used to break down and compare parts of a whole. Each bar in the chart represents a whole, and segments in the bar represent different parts or categories of that whole. Different colors are used to illustrate the different categories in the bar.

To create a stacked bar chart, run a query with at least two indicators. Then go to ‘Settings’ while on the ‘Bar Chart’ visualization, and click on ‘Stacked’ in the ‘General’ tab under “Bar treatment”. The two (or more) indicator bars will be stacked on top of each other to form the stacked chart.

Question 6

How do I reorder the list of my indicators?

Accepted Answer

You can rearrange the list of your selected indicators in two ways. Both ways will update your visualization to reflect their new order.

First: lick and hold/grab the six dots to the left of the indicator you want to move and drag it up or down.

Second:

Go to ‘Settings’
Select ‘Series’ button
Click on and drag the indicator you want up or down.

See the following image for an example of reordering indicators on the platform. This method will not change the order of indicators on the query page.

Më së shumti të lexuara

Kategoritë