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.

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.

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.

For more information, see Displaying total boxes of fruit sold in the last three months

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