![]() The sumOfVisibleSums statistic requires additional set-up to be properly displayed: The sumOfVisibleSums formula allows you to provide a sum of any rows that are displayed within your dashboard table / chart. The above example will produce a table that changes both the number of products displayed, as well as the base for each segment defined in your table, depending on the displayed rows. Row stats=formula stats.prec=0 q18.any "Total Interviewed" See Creating Dashboard Filters for more information on table and chart filters.Įxpanding on the base example, if Product C was only to be displayed to participants from a specific country, you can use the effectiveBase formula, along with local filters and the showif keyword, to have a dynamically changing base: table id=db-74 Average Product Expenditure by Gender This is particularly useful when using local table/chart filters, along with the showif functionality. The difference between base and visibleBase is that the latter will show the base only based on rows displayed in your table/chart. Similar to the base formula, visibleBase displays a count of all participants who count toward a specific segment. Seeing as not all responses are mandatory, and "Product C" is asked conditionally, the above example will show you the row selection frequencies for males and females based on the sums of each product: The below example uses the same base question asking the participants how much they would spend on your products, but uses a custom formula to calculate the frequency of provided answers for each product: table absSum Custom Formula The absSum statistic can also be used as part of other custom formulas. This displays the absolute values of your q20 question summed up together: If you wanted to see the total amount of currency going in and out of a business, you would use the the absSum statistic: page sum You can represent the total net gain of all companies by using stats sum: table id=db-80 Sum Where some companies can have a net revenue loss, and may input negative values for that question. Consider the following net revenue question as an example, where negative values can also be input: ![]() ![]() The difference between the two is that absSum uses the absolute values of any data input. ![]() The absSum statistic works similarly to the sum statistic, as it provides a sum of all response values provided by your participants. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |