Uncategorized
True or False? It is better to hard code dates instead of using relative date range expressions?
True False
0 Comments
November 10, 2020
Menu
Uncategorized
Consider the following screen grab. The output format of the date pickers are set to Unix format. How can you use the filter actions to filter the bar/line chart?
Put a hidden data to the bar/line chart which contains the dates in unix format, check that format type is set to number and place filtering logic to filter the…
November 10, 2020
Uncategorized
In which of the following scenarios is DATE_STARTOF the optimal date function to use? Select ALL that apply.
To find values in the last 30 days To find values in the current day To find values between two randomly selected dates To find values from “last week” To…
November 10, 2020
Uncategorized
Adam has an Excel datasource set up in his Klipfolio account. Column 1 of the datasource contains the names of new customers in the past month and Adam suspects that the entries of this column have leading and trailing blanks. What is the function Adam should use to confirm this?
CONCAT SUBSTITUTE URLDECODE URLENCODE None of the above
November 10, 2020
Uncategorized
Which non-date functions could be used to find dates in a given date range?
SELECT and BETWEEN IF and BETWEEN SELECT and OR OR and BETWEEN
November 10, 2020
Uncategorized
Consider the following array of data: ARRAY(“Apple”,”Orange”,”EggPlant”,”Apple”,”Zucchini”,”Carrot”,”Orange” ,”EggPlant”,”Kale”,”Bananas”). What function would you use to replace “EggPlant” with “Brinjal” AND “Kale” with “SomeGreenThing”?
REPLACE SUBSTITUTE SUBSTITUTE_REGEX REPLACE OR SUBSTITUTE All of the above
November 10, 2020
Uncategorized
Match the Klipfolio Date and Time Functions below with the common use case where you would use them.
DATE— = — Used to convert a human readable date string (2015/01/01), into a computer readable date string known as Epoch or Unix time. Correct DATEVALUE— = — Used to…
November 10, 2020
Uncategorized
Consider the following scenario: You’re the owner of a paint shop and you’re making a Klip that has a table showing the number of one-gallon paint cans customers have purchased. You want to show the 10 customers that purchased the most of amount of paint cans. If you use the “Top” filter action on the column showing the number of paint cans, you need to apply the sort action first.
True False
November 10, 2020
Uncategorized
Mitch is building a sparkline component and wants to add a hidden data component to it. Which one of these methods can Mitch not use to add the hidden data component?
Properties tab of the component Control panel on the right hand side Right click menu of the component Data tab of the component None of the above
November 10, 2020
Uncategorized
True or False? The Indicators panel lets you apply colour changes to values, change the background colour of cells, and assign icons based on conditional thresholds.
True False
November 10, 2020
