• How do I edit a custom calculation?

  To edit the formula of 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 ‘Edit Formula’ from the dropdown menuFew readers

• Can I group my indicator by something other than date?

  Yes, you can. For example, as shown in the picture below, you can disaggregate your indicator by ‘Gender’. The results will be shown as male, female or unknown, for example in this case. To group your result in multiple ways, in addition to date (date grouping is always required since Epi curves are time based): Select your indicator and aggregate it by date (e.g. day or week). Go to ‘Group by’ and add the dimension (e.g. gender, country) you want to disaggregate on. Go to ‘Settings’,Few readers

• How do I change the number of results shown in my chart at a time?

  The bar chart by default displays 50 results after a query. This number can be reduced to as low as 20 or increased to show all data in the query. To change the number of results you would like to see by default: Go to ‘Settings’ In the default ‘General’ settings tab, under ‘Display options’ section, click on ‘Limit results’ dropdown and choose a number. This automatically changes the number of results shown in your bar chart. Alternatively, you can drag the results slider (found below tFew readers

• How do I aggregate the query results by time?

  See section on ‘How do I group my analysis results by time?’. For most indicators, this setting will sum all the individual values in the time bucket (e.g. all month values for a given year) together. However, some indicators are of type “Average” or “Last Value” by default; for these indicators, this setting will apply the same operation across all values in the time bucket.Few readers

• What is the setting functionality?

  The setting functionality allows you to amend and improve the ‘look’ of your visualisations, and depending on which, it will have two or more of these four tabs: ‘General’, ‘Series’, ‘Axes’ and ‘Legend’ The general tab allows you to select the chosen indicator(s) for visualisations with display options, and label axes and fonts correctly. The series tab allows you to rename the selected indicators, select display of values appearing on graph and coloring options. The axes tab allowsFew readers

• What is Map visualization?

  The map is used to display data geographically. By clicking on each dot on the map you can see the name of the geography, indicator name and its value for the queried date range. To see the results for only a particular geography, the user can use the search box found at the top of the right side of the map. By inputting a search value you can limit the result to the search criteria. (https://storage.crisp.chat/users/helpdesk/website/-/f/e/1/4/fe145037bc44d000/3f39891d-ed2c-4d18-bbbd-dc5dFew readers

• How can I overlap the disaggregation in my Epi curve?

  The default setting in the platform stacks your result on top of each other. If you prefer your results to be overlaid (overlap) instead: Go to ‘Settings’. Select ‘Overlaid’ under ‘Bar Display Settings’. Finally click on ‘Close’. The results should be overlaid now. The above works both with a single indicator with an aggregation (in addition to Date) and with two or more indicators. (https://storage.crisp.chat/users/helpdesk/website/-/7/4/9/6/749665282f731c00/461022b5-f785-4cbc-b5Few readers

• How do I add or rename the subtitle to my visualization?

  To add or edit the subtitle of your visualization, go to the ‘Settings’ button at the top left and update the subtitle in ‘Subtitle’ under the ‘Title’ section.Few readers

• How do I merge cells in my table?

  When two or more group bys are used, there may be many rows and it will be harder to see the data in an organized way. Merging your table cells makes that easier for you. See below the cells that are merged for each state. To merge your cells: In table view, go to ‘Settings’, and Tick the ‘Merge Table Cells’ boxFew readers

• How can I remove pagination for table results?

  When your query results include many rows, the table will automatically paginate results. This means that you will need to click on the arrows on the bottom right of the Table visualization to explore more results than those shown by default. If you would like to see all your results on one page, however, you may untick the ‘Paginate results’ button in ‘General’ tab in ‘Settings’. This will make all results appear in a scrollable list instead.Few readers

• How do I share queries and visualisations?

  The share feature, on the top right hand side, allows you to share your query and related visualisation by email or as a link.Few readers

• What is Heat tiles visualiztions?

  Heat tiles allow you to visualize an indicator over time and across geographies. By default, similar to the scorecard, this view shows you data with high values in red, and low values in blue. This allows you to see temporal data across geographies easily. The heat tile view is best used to visualize how concentrated (or top-heavy) results for an indicator are, as well as any potential seasonality of results. (https://storage.crisp.chat/users/helpdesk/website/-/8/4/e/d/84ed674c0ff3c000/a2Few readers

• How do I show the total of my result in a bar chart?

  The platform allows you to add a separate ‘total’ bar to your bar chart. This is possible by clicking into the group by tag in the query form and checking “Include total values”. Doing so will compute a total across all values for that group by.Few readers

• How can I convert my table into a scorecard?

  To switch between Table and Scorecard visualizations, go to the ‘Settings’ button and change ‘Table type’ to ‘Scorecard’ in the ‘General’ tab. The scorecard is a colorized table which takes the values in each column (indicator) and colors the values based on a spectrum from high to low (or low to high). Values on one end of the spectrum are colored green; values on the other end are red. Intermediate values are given a color between the two based on their magnitude. The scorecard is best usedFew readers

• What is the Box Plot visualisation?

  The box plot enables you to understand the distribution of your data (i.e. min, max, median, quartiles etc.), highlight outlier data points for investigation and the density of the data at different values using the violin plot. The boxplot can be used across a wide range of use cases including identifying outliers for epidemic investigations, reporting data quality issues and understanding seasonality of disease burden over time. To successfully query a box plot, it is very important to use moFew readers

• How do I duplicate my query?

  To create a copy of your query, click on the down arrow next to the query tab (e.g. ‘Query 1’) button at the bottom left corner of your monitor and then on ‘Duplicate.’ A copy of your current query is made available on a new tab right next to the current one -- which includes all query selections, visualization settings etc. Click on the new tab to view or start working on the newly created query. (https://storage.crisp.chat/users/helpdesk/website/-/d/5/7/b/d57b3272f2b5a800/3d3e56e1-2d50-45Few readers

• How do I apply the ‘Enable NOT filter’ to my time filter?

  The ‘Enable NOT filter’ is an exclusionary filter that allows you to remove certain time periods from your query. For example, assume you want to exclude last year’s data because it has not come in yet. Then: Select an indicator and ‘Year’ as your time ‘Group by’. Then go to the date picker in the ‘Filters’ section, and select ‘Last Calendar Year.’ Click on ‘Enable NOT filter’, and then Click on ‘Apply Date Filter’ to finalize.Few readers

• How do I add a new total row to my table?

  The platform allows you to add a ‘total’ to your query results for tables. This is possible by clicking into the group by tag in the query form and checking “Include total values”. Doing so will compute a total across all values for that group by. Note this is not a naive total — it is computed in the backend and so it represents the correct aggregation. You can also add subtotals to your table. You do so by enabling totals in more than one group by in the table.Few readers

• How can I retrieve my recent queries?

  You are able to retrieve your most recent queries in two ways: Your most recent querying activity across all AQT tabs will be restored when you go to the AQT page. Your recent queries are saved on your homepage for your reference. The homepage is the landing page you see first as you log into the platform. Scroll down to ‘My Recent Queries’ section to see and retrieve your last 10 queries.Few readers

• How do I rename the title of my visualization?

  To change the title of your visualization, go to the ‘Settings’ button and update the title of your visualization in the ‘Title’ section. An easier way to do so is to click on the first indicator listed under ‘Indicators’ section on the left and change title under the ‘Label’ section.Few readers

• In what different ways can I visualize query results on a map?

  You can display your query results on a map in the following ways: Dots - data will show as dots on the map. Scaled dots - the dots will be of different sizes to reflect the size or magnitude of the indicator being visualized. Colored tiles - tiles on a map are the geographic shapes of a country’s administrative hierarchy, such as the shapes of its regions.The color or intensity of colored tiles can be defined to indicate the magnitude of the indicator. To make a selection, go to the ‘Few readers

• What is the custom calculations field counter?

  When editing custom calculations, it is useful to know how many fields are already included in the calculation. To the right of each indicator or field you will see a bubble with a number in it. This is the field counter. As you add fields, the count will increase accordingly.Few readers

• How do I delete a custom calculation?

  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 menuFew readers

• Can I customize the ‘indicator operation’?

  Every indicator integrated is given a default operation which informs the platform on how to aggregate the data correctly. In most cases, the default operation is the “Sum” operation, which adds the data (e.g. results from various years) within the scope of your analysis to provide you with totals. However, you can customize the default indicator operation by clicking on the indicator tag in the query form. A number of additional operations exist including: Sum: returns the sum of all the vaFew readers

• How do I create maps with colored tiles?

  Colored tiles are the shapes of the country’s administrative hierarchy. For example, each region has a shape and this shape can be colored. To create a map with colored tiles: Open ‘Settings.’ On the ‘General’ tab from the ‘Selected field’ dropdown, select the indicator for which you would like to make the map. Then on the same page, from the ‘Display’ dropdown, select ‘Colored tiles.’ By default, tiles and dots will be blue on the map. See the ‘Filter and Color’ section on how to deFew readers

• What is the ‘Filter’ function?

  Filtering results (which is different from filters you used to set the scope of your analysis) will help you to limit the results shown on your visualizations after you run your initial query. By applying different conditions and rules, you can, for example, remove below average results from your visualization. More complex filtering, such as, ‘remove top 10 results’, ‘bottom 50 results’ and ‘results equal to null’ can also be constructed.Few readers

• How do I show my results vertically on a bar chart?

  By default, the platform shows values at 45 degrees above each bar in a chart. When you have many bars in your chart, the values may conflict and overlap across bars making it difficult to read. To avoid this you can rotate the values to 90 degrees (vertically). To do so: Go to ‘Settings’. In the ‘Display Options’ section, under ‘Value label rotation’, choose ‘VertFew readers

• How do I use the pivoting function?

  By default, Tables are displayed with indicators as columns, and group bys as rows. Pivoting the Table moves your ‘group by’ to columns and the indicators to rows. To pivot your table: Go to ‘Group by’ and add the dimension you want to disaggregate on (e.g. State, Month). Go to the ‘General’ settings in ‘Settings'. Under ‘Display options’ click on the ‘Pivot Table By’ dropdown menu and select the dimension that you would like to pivot by. By default, tables are pivoted by indicators, as sFew readers

• How do I filter my query results?

  To filter your query results: Run your query and go to the visualization of your interest. Click the ‘Filter’ icon at the top and then on ‘+Add Filter Rule’. In the ‘Fields’ dropdown, choose the indicator you want to filter. This dropdown will have all the indicators you have initially chosen for your query. Under the ‘I want to...’ box select ‘remove’. From the next dropdown make a selection based on your required filtering. The options are: a. Top: removes ‘x’ number of resultFew readers

• How do I define a new cohort?

  The cohort creation screen is split into 4 main parts: Cohort summary section: this section at the top of the tool represents the main numeric result as well as a summary of your cohort groups in verbalized form. Cohort visual representation: a diagram that describes the logical relationships between groups and conditions in your cohort. Cohort definition section: the main panel where you define cohort groups and their conditions. Each cohort group is defined by 1 or more conditions thatFew readers

• How do I know if a visualization has been ‘unlocked’?

  Once you have selected your indicators and group bys for a query and the query form updates, the visualizations available change. Available visualizations turn BLUE. Visualizations that have unfulfilled requirements stay GREY. Unfulfilled requirements will appear on the Requirements Panel. Click on each visualisation to view the visualisation requirements that are in the form of number of indicators, number of group bys and type of group bys. All fulfilled requirements are marked with aFew readers

• What is Time series visualization?

  This visualization enables you to see data for the selected indicator and aggregation values (e.g. locations) over time. Zoom into a specific time period by clicking and dragging a box around the time period to have a closer look and understand the result. You can also see the specifics about an indicator by hovering over it. The time series is best used when you want to view data for a specific geography over time to view temporal trends in the data. You can now set upper and lower bounds tFew readers

• How do I represent an indicator as a line on the bar chart?

  On the bar chart, it is possible to visualize an indicator on the Y2 axis as a line graph. This is helpful for visually comparing bar and line data for two or more indicators of varying units (e.g. % vs. of cases). In order to do so: Add an indicator in your query to the Y2 axis in the ‘Settings’ (see ‘How do I create a second y-axis?’) Go to the ‘Settings’, and under ‘Display Options’ select ‘Display Y2 as Line’ (https://storage.crisp.chat/users/helpdesk/website/-/1/1/8/3/1183d223aFew readers

• How do I create a second Y-axis and set a goal-line?

  When analysing two or more indicators, a second Y-axis can be created and assigned to indicators. This can be done in the ‘Series’ tab in ‘Settings’. To assign an axis, click on the dropdown under ‘Y Axis’ column and select the preferred axis for each indicator in the visualization. A goal line can be added by hovering over the Y-axis and clicking to set a goal line. Click on the 'add' button next to ‘Goal Line’ under ‘General’ tab in settings, and configure your goal line. (https://storageFew readers

• How do I ensure an indicator in a custom calculation is treated as 0 instead of NULL to prevent NULL results ?

  You can ensure any indicator in your formula is treated as 0 by clicking on the tag in the formula and checking the setting ‘Treat NULL as 0’.Few readers

• How do I use the Enable NOT filter?

  The platform allows you to use the NOT filter option when multiple selections are required. This allows you to remove the selected values from your results.Few readers

• How do I edit the legend in my visualization?

  Legend describes and helps you differentiate between two or more indicators used in a visualization. To edit the legend, go to ‘Settings’ and then to the ‘Legend’ tab. You will be able to edit the legend’s font type, color and size. You may also choose to hide or show the legend by (un)ticking the ‘Show legend’ button. Note that not all visualizations have legends. To edit the text used to represent indicator names, go to the ‘Series’ tab in ‘Settings’ and change the series name. Click ‘Close’Few readers

• How do I flip coloration on a scorecard?

  By default, the highest values for the indicators will be green and lower values will be red. If you want to flip the coloration (for instance in the case of disease burden where you want the locations with the highest burden of disease to be red), navigate to the chart settings and click on the ‘Invert coloration’ dropdown below the scorecard/table option and choose the indicators for which you would like to invert the coloration.Few readers

• How do I download visualizations?

  Visualizations can be downloaded by clicking on the ‘Share’ icon at the top of the visualization you are working on. After clicking on ‘Share’, go to the ‘Download’ tab to see download options. You can download an image in one of four sizes: Fullscreen: a square-shaped screenshot Widescreen: a wide rectangular screenshot Current size: the shape and size currently seen on your screen Custom size: customize the height and width of the image in pixelsFew readers

• What is Table visualization?

  The table visualization displays the results of your analysis in rows and columns. This gives you a basic and standard way of seeing the data numerically. Sort the data based on any column by clicking on the column header. By using the search box at the bottom left of the table, you can also filter the table. For example, you could start by typing the name of a district and see results only for that district. (https://storage.crisp.chat/users/helpdesk/website/-/4/6/9/e/469e379f28835400/9Few readers

• What is the Epi curve visualisation?

  This visualisation enables you to visualise the onset of a disease outbreak. An epidemic curve is a statistical chart used in epidemiology to visualise the onset of a disease outbreak. You can view the results of an Epi curve by selecting the required indicator and grouping by the required frequency over the time filter. *Note all data displayed in this manual is publiclFew readers

• How do I know the number of results my query has returned?

  The total number of results your analysis has turned is shown at the bottom right corner of the table. Note all data displayed in this manual is publicly available and is not confidential in any way or form.Few readers

• How do I change the color of the bars?

  The color of the bars in your visualization can be changed in the ‘Series’ tab in ‘Settings'. By default, each series in the bar chart is given its own color but these can be customized. You can change the default colors by clicking on the color box and making a choice from the color menu in the ‘Series’ tab.Few readers

• How do I construct a query?

  To run a query, go to the Analyze page (click on ‘Analyze’ button at the top) and select your: Indicator(s) from the available datasets Aggregation level(s) (‘Group By’) Geographic and date range filters (‘Filters’) For each of the above sections, you will make selections by clicking on ‘Add+’. These selections will then be added to the query form in the form of selection tags. Each tag represents a query component that can be customized. The result of your query will be displayed iFew readers

• How do I show results at different levels of the geographic hierarchy?

  To specify your geographic aggregation level (‘group by’), Go to the Analyze tool page and select your desired indicators. In the ‘Group By’ section, click on the ‘Add+’ button to add an aggregation level. Select a geography (e.g. Province/State or Municipality) from the ‘Geography’ menu. By default, there is no grouping selected on the query page and results will be aggregated to the Nation level unless you specify otherwise. (https://storage.crisp.chat/users/helpdesk/website/-/6/Few readers

• How do I use advanced custom calculations in Javascript?

  Advanced custom calculations enable users to create more complex calculations using javascript. Below are examples of notation you can use to create calculations of varying complexity: Sum: this enables users to compute the sum of an indicator. Cumulative sum: this enables users to create a column which displays the cumulative totals for the chosen dimensions. Difference: enables users to calculateFew readers

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

  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 presetFew readers

• How do I group my analysis results in other ways?

  In some cases, the data sources integrated will contain other group bys. For example, Master Facility Registries (“MFR”) will include facility metadata such as “Facility Type” (hospital, private facility etc.) which can be used to analyze your data sources. In other cases, your indicator data will also include Gender, Age Group and other information that can be used to group your data. These groupings will be discoverable from the ‘Group By’ section.Few readers

• How do I show percentage values on a pie chart?

  To show percentage values on your pie chart, click on the legend provided at the bottom of the chart. In the example below, clicking on ‘Doctors’ and ‘Nurses’ at the bottom surfaces the corresponding values on the chart.Few readers

• How do I rename a custom calculation?

  To rename your calculated indicator, go to ‘Settings’, then ‘Series’ tab and change the series label.Few readers

• How do I re-use color rules?

  Existing color rules can easily be re-used across indicators. To re-use a color rule: Go to the ‘Series’ tab in ‘Settings’ Under ‘Add rules’, click on the blue plus (+) sign and select the existing color rule that you would like to assign to your indicator. Note that all color rules can be found below the series and can be assigned to more than one indicator.Few readers

• How do I abbreviate the values of each bar in my chart?

  When adding the value label to your visualizations and working with large number values, you can “abbreviate” the value using the K (thousands), M (millions) and B (billions) terminology. This will make your labeled visuals much cleaner. To abbreviate your results: Go to ‘Series’ in ‘Settings’ For the indicator you want to abbreviate, tick the ‘Show value’ box.Few readers

• How do I access my Insights?

  To access your Insights go to the ‘INSIGHTS’ tab on the left top corner of the Analyze page. Note that for the Insights to be active, you need to select at least one indicator on the Analyze page and ideally a Group By (‘BUILD QUERY’ tab). Insights are generated based on your query results so it may be worth checking for new or different Insights each time you adjust your query.Few readers

• How do I add a time filter at the indicator level?

  The platform allows you to add geography and time filters at the indicator level, providing you with additional flexibility in your analysis. To add a filter at an indicator level: Click on an indicator you have already selected and has been added to your query. Click on ‘Add+’ under ‘Filters.’ Specify your geography or time filter. By combining indicator-levelFew readers

• What kinds of insights are available to me?

  The following insight card types may appear based on your query results: Data Profile: A high level overview of your query results. This insight card will be available for most queries and includes a box and violin plot of your query results along with key metadata like the maximum and minimum values, mean, median, standard deviation, date range of available data and number of rows of data included in the specific query. (https://storage.crisp.chat/users/helpdesk/website/-/f/a/8/8Few readers

• What is a Pie Chart visualisation?

  This pie chart is a very dynamic visualization that enables users to split segments by group by or by indicator constituents. It also enables users to click into segments to drill down into individual groups and their distributions. You can view the results of a pie chart by grouping a single indicator across geographies or selecting multiple indicators across geographies. There are two main modes for pie charts under Settings: Indicator Breakdown and Grouping Breakdown. Indicator BreakdownFew readers

• How do I switch between percentage and raw values on a pie chart?

  You can select the value display-type on your pie chart. To do so: Go to the ‘General’ tab in ‘Settings’. Under the ‘Value type’ setting, select either ‘Percent’, ‘Raw’ or ‘Both’Few readers

• What is the Bar Chart visualization?

  Bar Charts allow you to see bars of aggregated data. By clicking over a bar you can see the name of the aggregation it represents (e.g. district name) and its indicator value. The bar chart is useful when you want to compare aggregated values across indicators and geographies for the entire selected time period.Few readers

• Why do the results in the cohort creation screen not match the results in my query?

  The cohort tool generates results independently of the query in ‘Analyze’. If you have query-level filters or group bys applied, the results in your query on Analyze will be filtered or grouped appropriately on top of the cohort definition.Few readers

• How do I set a goal line for my visualization?

  A goal line is a target, threshold or reference line you would like to make visible on your bar chart. Having a goal line on a chart allows you to show if the various bars are over or under this threshold. To add a goal line, go to ‘Axes’ tab in ‘Settings'. You can add a horizontal goal line by setting a value and label. Note that in order to set a goal line for a percentage, you must provide the goal value in decimal format (e.g. 95% should be entered as 0.95). (https://storage.crisp.chat/Few readers

• How do I choose the indicator I want to display on my visualization?

  Visualizations such as maps, heat tiles, ranking, scatterplot and hierarchy show only one indicator at a time even when your query consists of two or more indicators. To display other indicators that are part of your query, go to the ‘General’ tab in ‘Settings’ and select the right indicator from the ‘Selected Field’ dropdown menu. The chart will be immediately updated.Few readers

• How do I format the fonts on the axis of my visualization?

  To be able to format the x- and y-axes of your visualization, go to ‘Settings’ and then to the ‘Axes’ tab. You can edit the titles of the Axes, that of the labels and their font sizes.Few readers

• What kinds of map layers are available for my use?

  The map layers available for your visualization are the following: Satellite - a satellite picture of the geography Streets - a simplified view of the map showing major geographical attributes such as country and regional borders as well as roads and streets in cities and towns Light - a simplified map without details of such borders or streets. It helps you focus the reader’s attention to the specific geography the data addresses Dark - a simplified view of the map on a dark backgrFew readers

• What is Ranking Visualization?

  Ranking allows you to compare the magnitude of the attribute you are measuring with those of others over a period of time. Ranking also shows you the trend in the performance of your subject of interest over a period of time. Note: all data displayed in this manual is publicly available and is not confidential in any way or form.Few readers

• What is the Big Number visualisation?

  Big number visualizations are used for at-a-glance information on dashboards. There are two types of big number visualizations: Number: You can change your number to a pill view, color your numbers flexibly and select a secondary field. Number and Trend: You can use the number and trend visualization on dashboards to show the recent direction of data as well as the primary performance indicator. Note that you can enable ‘last value’ display in display settings so that you can now show a bFew readers

• How do I apply different query operations other than ‘SUM’ to my analysis?

  To apply operations other than the ‘Sum’ function to your indicator: Click on the indicator tag in the query form, and On the dropdown menu under ‘Operation’, make your selection. The new operation will automatically be applied to your selected indicator. Note: If you would like to compare different operations side by side, you can select the same indicatoFew readers

• How do I add custom colors to my query results?

  You are able to flexibly color results on the Maps and Table (Scorecard). This function is especially useful to quickly interpret the variability of your data visually. Run your query and go to the visualization of your interest i.e. map or table. Open ‘Setting’ and click on ‘Series’ Under 'Series', click on the blue plus (+) sign under ‘Color rules'. From tFew readers

• How do I delete my query?

  To delete your query, click on the down arrow next to the query tab (e.g ‘Query 1’) at the bottom left corner of your monitor and then on ‘Delete.’ The tab along with all its query will be immediately deleted. The information cannot be recovered.Few readers

• Why are there missing group by values in my results?

  During the data integration process, the platform matches new data sources to a source of truth representing the country’s administrative hierarchy. This is often called the Master Facility List (“MFL”). During this process, all geographical entities (Facility, Municipality, State etc.) from the source data is matched to this internal MFL -- which enables triangulation across a diverse number of data sources in the platform in a consistent way. When a certain geographical entity in the sourceFew readers

• How do I set upper or lower bounds in time series charts?

  You can set upper and lower bounds in your time series. To do so: Go to ‘General’ tab in ‘Settings’. Click on the edit button next to “COLORED BANDS” and choose your bounds. You can decide if you would like your bound to be at a specific value or if you would want a specific indicator to be the bound.Few readers

• How can I select a new visualization?

  There are two ways to get to a visualizations: The Quick options tab bar: located at the top left corner of the visualization tile, this tab gives you the most popular visualization from each theme. The Explore view: This tab opens the complete visualization menu and allows users the option of additional visuals from each theme.Few readers

• How can I use the logarithmic scale?

  Logarithmic scale is a nonlinear scale used for a large range of positive multiples of some quantity. Logarithmic scaling helps you better respond to skewness where one or a few data points are much larger than the bulk of the data. To apply logarithmic scaling, go to ‘Settings’, ‘General’ settings tab and click on ‘Logarithmic scaling’ under ‘Display options.’ YourFew readers

• Why is data missing from my query results?

  Data may be missing from your query results for a number of reasons. For example, your results may say “No data”. Some reasons include: Such an outcome may indicate data for this specific indicator, geography or time interval is unavailable in the source dataset. The platform can only display data available in the source dataset. The indicator you chose doesn't have data at your selected aggregation level. For example, if you choose an indicator from a dataset that only goes to province lFew readers

• How do I select an indicator?

  There are two ways you can find and select data of interest to you: via dropdown menus and search. To select from a dropdown menu: Go to the Analyze page by clicking on the ‘Analyze’ button at the top. Under the ‘Indicators’ section click on the ‘Add+’ button. You will see a set of indicators to choose from organized by data source. Click through the data sources to explore your data organized in sub-groups. Choose an indicator of interest by clicking on an entry in one of the groups. YoFew readers

• How do I reset my query?

  At times, you may want to start over and remove all query selections. To do so, click on the down arrow next to the query tab and then on ‘Reset.’Few readers

• How can I visualize two or more indicators on an Epi curve?

  To do so, add the indicators of your interest to the query and apply the appropriate group bys. Both indicators will be stacked on top of each other and will be displayed automatically.Few readers

• How do I name or rename my query?

  To (re)name your query: Click on the down arrow next to the tab showing the current name (e.g. ‘Query 1’) at the bottom left corner of your monitor. Click on ‘Rename’. Name your query.Few readers

• How do I customize the looks and feel of my table?

  The platform allows you to edit the style of the header and rows of your table. You can edit the font size, font color, border color, background color in addition to the title and subtitle of your table. To edit your table, go to the ‘General’ tab in ‘Settings’ and make various selections.Few readers

• How do I create a custom calculation?

  To create a new custom calculation, go to the Analyze tool page and: Run a query using the indicators you wish to use as constituents for your calculations. Click on the ‘Calculations’ icon at the top of the visualization window. A dialogue box opens. Give a name to your new indicator in the ‘Calculation Name’ field so it is easily identifiable in your visualization. Click on the indicators you initially selected (listed under ‘Fields and Calculations’) to add them to the formula. 5Few readers

• How do I show the values of each bar in my chart?

  To show the numerical values of each bar in the chart go to the ‘Series’ tab in ‘Settings’ and click on ‘Show value’ for each series whose value you want to be displayed on the chart. These values will appear above the bar.Few readers

• How do I change the style of your series to line or points regardless of which axis your series is?

  This can be done in the ‘Series’ tab in ‘Settings’ by making a selection from the ‘Visual Style’ dropdown.Few readers

• How do I display more than five results on the time series chart?

  By default, the time series chart displays the top five results, sorted by value. To be able to see more results at a time (i.e. 10, 20, 50, 100, All), go to the ‘General’ settings in ‘Settings'. Under ‘Display options’ click on the ‘Limit results’ dropdown menu and select how many results you would like to see on the chart at a time. Alternatively, you can further reduce the number of results shown by hiding results. Click on the legend representing the result to hide it from your time series.Few readers

• What datasets are available for my analysis?

  Specific datasets you are allowed to access and query are listed in the Analyze page. To see the entire list of datasets, click on ‘All Data’ dropdown menu.Few readers

• How do I create a new query tab?

  The default Analyze page has a single tab for you to start building a new query. You can add new tabs to create and work on multiple queries at the same time. To create a new query tab, click on the ‘+’ symbol at the bottom left corner of your monitor. A new query tab will immediately be added to your monitor.Few readers

• How do I specify a geographic filter for my analysis?

  A geographic filter enables you to decide the geographic scope of your analysis. For example, if you choose a specific municipality, only data for that municipality will go into the analysis of the selected indicators. If the filter is set to two or more specific states, then data only from those states will be available for your analysis. To select a geographic filter: Go to the Analyze page, and Under the ‘Filters’ section, click on the ‘Add+’ button and make a selection from the ‘GeogFew readers

• What is the Analyze page?

  The Analyze page is your primary means to interact with your data. This is where your analysis usually starts. The page allows you to construct basic and advanced queries and visualize the data in flexible ways. It enables you to select the indicators, geographies and reporting periods your analysis requires. The Analyze page also offers you various visualization tools such as bar charts, tables, time series, ranking diagrams, scatterplots and animated maps you can use to explore and present youFew readers

• How do I remove indicators from my query?

  To remove an indicator from your query click on the ‘X’ on the right side of the indicator tag.Few readers

• What is cohort analysis?

  Cohort analytics is a type of analytics that helps public health professionals compare individual patient cohorts over time; each cohort shares a common characteristic such as time of outreach, infection date, or treatment regimen that can be defined very granularly on any available data. By analyzing cohorts, M&E teams can assess cascades of care across cohorts and tweak features to their interventions to more granularly determine ways to increase metrics such as treatment retention, engagementFew readers

• How do I group my analysis results by time?

  To specify your time-based aggregation level (‘group by’), Go to the Analyze tool page and select your desired indicators. In the ‘Group By’ section, click on the ‘Add+’ button to add a time group by. You have two options: ‘Date Group' or ‘Date Extraction.’ Select a time group (e.g. Month/Quarter/Year or Month of Year/Quarter of Year). Note that ‘Date Group’ and ‘Date Extraction’ group bys are different: ‘Date Group’ enables you to organize your analysis by continuous month, quarterFew readers

• How do I rearrange the result in my visualization in ascending or descending order?

  By default the platform arranges your analysis results in descending order based on the first indicator being displayed. To rearrange the data in ascending order or vice versa, go to ‘Settings’ On the ‘General’ settings tab, then under ‘Display Options’, click on the ‘Sort order’ dropdown and select ‘Ascending’ or ‘Descending’ The data in the chart will be immediately rearranged using your sorting preference. If you have run a query with multiple indicators, you may also change the indicatorFew readers

• How do I create a stacked bar chart?

  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) indicatorFew readers

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

  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.Few readers

• What is the Insights feature?

  Insights is a feature in the Analyze tool that surfaces cards that summarize potentially interesting analytics about your query results along with 1-click actions to view these insights on visualizations. Insights makes it easier and faster for you to explore your data, identify valuable insights and express them on rich data visualizations. *Note all data displayed inFew readers

• How do I set Y-axis ranges on bar charts?

  When working with large variances in bar chart values, it may be useful to limit the values on the Y-axis to make information more readable. To assign a range for Y-axis values, go to the ‘Axes’ tab in ‘Settings’ and insert minimum and maximum values into the ‘Range’ text boxes.Few readers

• How do I remove the dark borders (lines) around my Epi curves?

  You can remove the border lines around your Epi curves to provide a simpler look to your visualization by going to ‘Settings’ and unticking the ‘Display bar borders’ box under ‘Bar Display Settings’. *Note all data displayed in this manual is publFew readers

• How do I show the total of my result?

  The platform allows you to add a separate ‘total’ bar to your bar chart. This is possible by clicking into the group by tag in the query form and checking “Include total values”. Doing so will compute a total across all values for that group by.Few readers

• How do I sort the data in the columns in alphabetically or numerically ascending or descending order?

  You can reorder the contents of a column in ascending or descending order. To do so, click on the header of the column you are interested in. This will automatically rearrange the alphabetical or numerical order of the values.Few readers

• How do I view my “most recently used” indicators?

  To view the indicators you used most recently, click on the ‘Add+’ button under ‘Indicators’ and then select ‘Most Recently Used Indicators’.Few readers

• How do I annotate visualizations?

  Annotations can be made to a visualization by clicking on ‘Download’ icon at the top of the visualization you are working on and then clicking on ‘Annotate’ button. Doing so opens a new window where you can make annotations and download the final visualization together with your annotations in the form of an image, PDF, Microsoft Word (DOCX) and or Powerpoint (PPTX).Few readers

• How do I create a horizontal bar chart?

  To create a horizontal bar chart, go to ‘Settings’ while on the ‘Bar Chart’ visualization, and select ‘Horizontal’ in the ‘General’ tab under ‘Bar direction.’Few readers

• How do I hide an indicator from the bar chart?

  When your query uses two more indicators it is possible to hide some of the indicators from the chart. This allows you to focus your chart on selected indicators without removing the indicators completely from the query results. You can hide indicators in two ways. Click on the name of the indicator you want to hide from the legend (series) shown at the bottom of the chart. The indicator will be immediately removed from the chart but its name continues to be visible in the legend. The indicaFew readers

• What is a custom calculation?

  This platform allows you to create new and more complex indicators, known as “custom calculations”, by mathematically combining existing ones in your query. The calculations tool lets you use both logical and mathematical operations to create these new indicators.Few readers

• What is the Visualization Picker?

  The visualization picker is a tool developed to enable users to browse supported visualizations and learn how to adequately query their data in order to unlock each visualization. Since the Analyze tool requires users to structure their data with groupings, this tool makes it clear why sometimes your visualization becomes “unfulfilled” by highlighting which requirements need to be addressed.Few readers

• Where can I access cohort analysis?

  You can access cohort analysis functionality in the ‘Analyze’ tool. In the Analyze tool, any indicator is defined with an ‘operation’. To change the default operation to ‘Cohort’: Click the indicator tag for a queried indicator. Select ‘Cohort’ from the indicator operation dropdown. Click ‘Build Cohort’. Customize your cohort of interest.Few readers

• How do I export query data?

  Visualization data can be exported by clicking on the ‘Download’ icon at the top of the visualization you are working on, and then on the ‘Data’ tab. Data can be downloaded as Excel.Few readers

• How do I customize the look and feel of my table?

  You can edit the title and subtitle of your table by going to ‘Settings’. On the ‘Settings’ tab, you can also edit the size, color and font type of your table’s title and subtitle. In addition, there are two main ways you can modify the look and feel of your table. In ‘Table’ mode, if you go to ‘Settings’ and then ‘Themes’, you can: Choose from a list of ready-made table themes which you can apply to your table instantly, or (https://storage.crisp.chat/users/helpdesk/website/-/f/8/1/8/f8Few readers

• How do I reorder the list of my indicators?

  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 theFew readers

• How do I filter my analysis results in other ways?

  In some cases, the data sources integrated will contain other filter bys. For example, Master Facility Registries (“MFR”) will include facility metadata such as “Facility Type” (hospital, private facility etc.) which can be used to analyze your data sources. In other cases, your indicator data will also include Gender, Age Group and other information that can be used to filter your data. These filterings will be discoverable from the ‘Filter’ section.Few readers