Klipfolio Expert
- True or False? The Labels in a drop-down list are optional.
- True or False? You can click on the “Selection Options” link for an xpath element to be able to hand edit the xpath for the element?
- Himadri is an admin user of a Klipfolio account and is reconfiguring a Facebook Ads datasource made by Arshad, another user of the same Klipfolio account. When she reaches the OAuth token selection step, she does not see any Facebook OAuth tokens available for selection. This is because the OAuth token used to create the datasource is owned by Mitch and was not shared with other users.
- Seth is building a table component. Column 1 of his table has 10 entries and a hidden data component has 20 entries, how many rows does Seth’s table have?
- 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?
- Which one of the following are valid options for the prefix of the datasource email address when using Klipfolio’s email attachment connector?
- Using the image below, what properties can you tell have been set for the map markers?
- You can reference the value(s) of a component in another component in the same Klip.
- You have a datasource where column A is showing a list of country names (where some names are repeating themselves). You apply a member filter check-boxes to include the following countries: Canada, England, Poland and India. When the datasource refreshes Brazil is newly added to it. What happens to the component using the filter when new data is added to it?
- You have a datasource whose column A contains date/time in unix format. You wish to display the date in the calendar format of MMM dd, yyyy but you also wish to include the hour and minute information (with a separator of :). How do you specify the time to match the requirement above?
- A pie chart can only have a maximum of 6 slices.
- How many different ways can you manage the billing for your Client accounts?
- What function would you use to combine multiple true/false conditions?
- Which of the following are true of Klipfolio’s Klip Gallery templates?
- True or False? The MAP function with the DATASOURCE function is used when a Klipfolio variable is used in the xpath?
- Which of the following can be used to control both which specific dashboards are visible to each user, and also what Klipfolio features each user has access to?
- Jieyi is building a bar/line chart showing the amount of new customers acquired by date and is using the DATERANGE( ) function to generate the X-axis between the start of the year and today. However, her datasource contains gaps for some dates. What is the function that Jieyi should use to align the data with gaps to the X-axis?
- What is the difference between a filter action applied to “Values in view” vs. “Values in source”?
- How do you get the element names for a list of elements in a JSON or XML data source (such as the country codes in Facebook)? Select ALL that apply. Note: One answer is better than the others, and is therefore worth more.
- 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?
- A custom company property is considered a variable
- True or False? You can create custom maps in Klipfolio?
- Which data formats does Klipfolio support when creating data sources using the Web Accessible Resource connector? Select ALL that apply.
- Consider the following statement: Datasources in your KIipfolio account refresh only if there is an active session (such as a user being logged into the Klipfolio account or a published link being used).
- If you’re using the Condition tab in the filter action window, what is the difference between the “Match All” vs. “Match Any” options?
- True or False? You can use DATASOURCE with Dynamic Data Sources?
- What function do you use to convert a date string into “epoch time” in order to perform a calculation? NOTE: Epoch time is a computer readable date string. It is the number of seconds that have elapsed since Jan 1 1970.
- True or False? When connecting to a SQL Database, an SSH Tunnel can be used to increase security?
- What is the result of the following formula? DATEVALUE( DATE_STARTOF( DATE_ADD( DATE(“2017-11-15″,”yyyy-MM-dd”), year, “-1”), quarter), “yyyyMMdd”)
- Which of the following is true of the LOOKUP function?
- You have a datasource where column A is showing a list of country names (where some names are repeating themselves). Do the function GROUP(@A:A) and the group action applied to @A:A yield the same result?
- To use a variable in a Klip, you must have:
- Josh wants to show websites and time on website in a table. He wants to set time on website metric to format as duration (hh:mm:ss). What should be the format of his raw input data?
- Ivan is writing an api query, and from the api’s documentation he finds out that the response can be filtered to only show data created since a defined date (using the “created_since” parameter). Ivan wants to filter the data that was created since the beginning of the month, and the input format of the “create_since” parameter should be “yy MMM dd”. What is the date/time function Ivan should pass to the “created_since” paramter in his query?
- Which of the following statements about this bar chart are true? Select ALL that apply.
- How do you enable the option to see the Klip resizing handle, which allows you to change the size of a Klip on the dashboard?
- Replacing “view” with “debug_info” in the data source url will help you do which of the following.
- You can reference the value of a component in one Klip on a component in another Klip using formula or results reference.
- Which of the following relative date expressions would you use to look for “Start of the current year”? Assume this particular API expects dates in the format of yyyyMMdd.
- Kaushi is the builder of a Klipfolio partner account, and has imported a dashboard from the parent account to a client account. She now wants to update one of the Klips in the parent account and propagate the changes to the client instance of the Klip. Under which of the following scenarios can she use the “Update client instance” button to do achieve this task?
- With the appropriate Role(s) and Permission(s) a Klipfolio User can add a Klip to a Dashboard in which of the following ways? Select ALL that apply.
- When plotting colour data on a Map component, the map will be shaded from light to dark according to what?
- Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change it to ARRAY(“fruit”,”fruit”)?
- How do you define a variable in a formula?
- Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change apple to *pple AND banana to b*n*n*?
- True or False: Dashboards published privately require a password?
- True or False? the SWITCH function can have multiple case and value parameters.
- You can duplicate an indicator within the same sub-component.
- When plotting region data on a Map component, which function is most commonly used to align data from the Region ID data source to the numeric values for each of the regions?
- What are the assets within a Klipfolio account that can be duplicated?
- True or False? You can use the Klipfolio relative date range expressions if the data source you are accessing expects the start and end date in epoch format.
- What are the different ways I can log into a Client Account?
- Yvonne is writing formulas using the following Klipfolio functions: COUNT_DAYS, DATE_ADD, DATE_IN and DATE_STARTOF. What is the input date format Yvonne should use to ensure the Date/Time functions are working correctly?
- Klipfolio lets you connect to how many different web based data sources?
- When plotting markers on a Map component, these two data points are required:
- What Klipfolio assets are stored in the Library?
- In which of the following scenarios is DATE_STARTOF the optimal date function to use? Select ALL that apply.
- Seema is an admin user of a Klipfolio account, who is currently setting up other users. She can get a user invite link and a link to reset the password from the user’s settings, which can then be passed along to the users.
- A user group is the same as a user role, the terms are interchangable
- Which of the following statements are true about adding Users in Klipfolio? Select ALL that apply.
- Shima is making a table showing financial data aggregated by month. The list of aggregations for one of the table columns only has count, count distinct, first and last options. What is the cause of this?
- Consider the following scenario. You can find the refresh info for a given datasource (including any errors) by going to the information section of the datasource and selecting the “Refresh Info” link from the options available on the left-hand side.
- Which of the following statements are true about displaying Klipfolio on a wall-mounted screen? Select ALL that apply.
- The following syntax can be used to specify a default function to be performed if no cases match.
- When importing dashboards or klips, the variables in formulas do not get imported
- Klipfolio has data sources (with country, state, or provincial IDs) for which of the following maps? Select ALL that apply.
- A dynamic datasource can only have one dynamic property.
- 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.
- When you save a copy of a Klip, it duplicates the Klip and creates a copy of the datasource(s) associated with that Klip.
- What function would you use to get a list of the unique values in a data set?
- You can have multiple components in a single Klips.
- In which of the following scenarios is DATE_IN the optimal date function to use? Select ALL that apply.
- Which of the following are valid methods for creating data sources in Klipfolio? Select ALL that apply.
- Jason is setting up users in his Klipfolio account, these users can login to Klipfolio using an external application.
- True or False? Dashboards, Klips, and Data Sources can all be shared?
- In which of the following scenarios is the DATE_ADD function the optimal date function to use? Select ALL that apply.
- What is the actual limit to the amount of data that can be used in any one Klip?
- Stephen is a builder of a Klipfolio partner account, which manages 10 clients. Also within Facebook business manager, Stephen has permission to access insights of his clients’ Facebook pages and ad accounts. He wants to build out a template Facebook dashboard in Klipfolio, which he then wants to import to his clients accounts and have it configured to show their specific Facebook data. What is the best practice to create such a template dashboard?
- How can you get rid of column headers from a visualization?
- True or False? Only Admin Users in Klipfolio can create variables?
- You can add a user to a Klipfolio account without sending them an invite notification email.
- Which authentication types can be used when creating a data source using the Web Accessible Resource Connector?
- True or False? In order for user input controls to change data in a Klip, the user input control must have a variable associated with it.
- It is possible to enable dark theme for all users without using custom CSS
- You can include a Klipfolio Date/Time function such as TODAY( ) or YESTERDAY( ) in a REST API query.
- What is the data size limit of any one data source in Klipfolio?
- How does White Labelling in a Partner Account affect that Partner’s Clients?
- Fill in the blank: You can have up to __ Klips per dashboard.
- Which of the following customization options are available with Klipfolio? Select ALL that apply. (Question Type 2)
- Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change it to ARRAY(“Apple”,”Apple”)?
- What types of data formats are supported by Klipfolio?
- How often do Klip embeds refresh?
- You wish to convert 20171201 to December 01, 2017 using the DATE_CONVERT function as follows. Fill in the blank by selecting one of the following options: DATE_CONVERT( “20171201”, “yyyyMMdd”, ___).
- Consider the following scenario: Within your Klipfolio account, you have two variables with the same name, one is “Klip” scope and the other is “All Dashboards” scope and the variable with the Klip scope has precedence.
- True or False? In a gauge component, Indicators override colour ranges.
- Which one of the following methods can be used to assign a value to a variable within Klipfolio?
- Zeek is using the following Klipfolio date function to specify the “start_date” parameter in his api query: {date.add(-5).startOfMonth.format(“yyyy MMM dd”)}. If today is December 3, 2017, what is the value that is being input into the “start_date” parameter?
- Pick the correct syntax of the SLICE( ) function which removes the last row from column A.
- How do you define a variable in a dynamic data source?
- You can schedule a specific time a datasource refreshes using the Klipfolio API.
- Prerna is building a bar/line chart which shows the number of social media followers acquired by month and wants to show two series from two different datasources: one to show the current year’s data and the second one to show previous year’s data. What is the function Prerna should use to align the data from two different datasources?
- True or False? A Klip component must have at least one data source?
- True or False? User input controls can control data in more than one Klip.
- True or False? Variables can be used in data source queries?
- Using the image below, select all scenarios where the variable “tm_country” is properly used in Klipfolio. Select ALL that apply.
- In a Klipfolio partner account, you can import dashboards from:
- Which of the following customization options are available with Klipfolio? Select ALL that apply. (Question Type 1)
- True or False? A User can only be part of one Group.
- What is the name of the header entry that should be used for authentication when using the Klipfolio API?
- Users in the Parent (Partner) account cannot have access to certain Client accounts
- Patrick is building a pie chart Klip for his Website Traffic dashboard using Google Analytics data. The pie chart shows sessions per channel and Patrick wants to exclude the slices of the pie chart that corresponds to “Referral” and “Paid Search” channels. The best practice for removing these channels through filter actions would be to select their names from member list and use the exclude feature.
- True or False? A User can be assigned to more than one role.
- True or False? Any Klipfolio customer can publish dashboard links?
- Can you use negative numbers in the SLICE function?
- Which of the following statements are true about “Roles” in Klipfolio? Select ALL that apply.
- What is the best way to share a dashboard with your colleagues if they are not users of your Klipfolio account?
- Zach wants to use the Klipfolio API to upload a file. Which one of the following commands does he need to use?
- Take a look at the Data Source and Klip Below. In order to build the “Delayed Units” Series, why is it necessary to use the LOOKUP function?
- Fill in the blank: You can have up to __ datasources per formula.
- True or False? A Klip must have at least one data source?