Measures and Dimensions

every chart has a number of measures and dimensions that can be visualized the number of dimensions and measures needed for the chart is indicated by a status message in the chart preview section the measures and dimensions on the chart are configured through the query tab in the chart configuration section all of the available fields that can be selected as a measure or a dimension are listed in the left side of the query section the right side shows the currently selected measures and dimensions measures to add a measure to the query, either click the + button to the right of the measure in the measures list, or drag and drop the measure into the marked placeholder under edit measures to remove a measure from the query, click the x button to the right of the measure in the edit measures list measures have an aggregate function that is used to calculate the numeric value of the data item this function must return a number all fields except numeric fields have one available aggregate function, count of numeric fields also have sum of, average of, and min of options to change the aggregate function for a measure, click on the measure and select the desired function from the drop down menu dimensions to add a dimension to the query, either click the + button to the right of the dimension in the dimensions list, or drag and drop the dimension into the marked placeholder under edit dimensions users can select as many dimensions as the chart type allows once all available dimension spots for the chart are filled, adding a new dimension will remove one of the existing dimensions to remove a dimension from the query, click the x button to the right of the dimension in the edit dimensions list the order of dimensions in the query matters to reorder a dimension, drag and drop it to the desired location in the edit dimensions list date fields support multiple options for the group by function select from group by day of week, group by week, group by month, group by quarter, group by hour to change the function, click on the dimension and then re select the desired function from the drop down menu