Common scenarios for building Klips

In our scenarios articles,  a Klip is built using a common set of formulas. The summaries below show you when to use these formulas.

Bar/Line Chart component

Klip Title: Counting open tickets by technician name

Use this example to align data that is either sparse or incomplete.  This Klip is a good example of how to use the LOOKUP function.

Instructions count the data.

For more information, see Counting open tickets by technician name

Klip Title: Counting yes and no records by date

Use this example to align data that is either sparse or incomplete and meets a specific condition.  This Klip is a good example of how to use the LOOKUP function.

Instructions count the data.

For more information, see Counting yes and no records by date

User Input Control component

Klip Title: Displaying total boxes of fruit sold in the last three months

Use this example to displays results based on a selecting a specific time period.  This Klip is a good example of how to use the AND and OR condition with the SELECT function.

Instructions sum the data.

Klip Title: Counting all tickets by quarter, by month, by weekday

Use this example to see results based on date range.  This Klip is a good example of how to use the DATE_UNITVALUE function with the SWITCH function.

Instructions count the data.

For more information, see Counting all tickets by quarter, by month, by weekday

Table component

Klip Title: Sorting data to display the video with the highest number of views

Use this example to sort data in a table. This Klip is a good example of how to use the SORT function.

For more information, see Sorting data to display the video with the highest number of views

Klip Title: Selecting start and end dates to display number of boxes sold by country

Use this example to allow a user to select a start and end date when grouping data using drill down. This Klip is a good example of how to use a date picker.

Instructions sum the data.

For more information, see Selecting start and end dates to display number of boxes sold by country

Pie Chart component

Klip Title: Displaying numbers and percentages in a pie chart legend

Use this example to return both the number and percentage for a list of values. This Klip is a good example of how to use the CONCAT AND NUMBERFORMAT functions.

For more information, see Displaying numbers and percentages in a pie chart legend

Klip Title: Displaying total number of surveys as a percentage by country

Use this example to create a pie chart that shows a percentage for a list of values. This is a good example of using the SUM function and formatting as a percentage.

Instructions sum the data.

For more information, see Displaying total number of surveys as a percentage by country