Certification Answers

We help you to pass your exams

EN FR ES DE IT PT RU PL NL TR JA

CertificationAnswers

In which of the following scenarios is DATE_STARTOF the optimal date function to use? Select ALL that apply.

By

 

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 find values between the start of last month, and another given date

 

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?

By

 

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 data where it is greater than or equal to the variable value for the start date and less than or equal to the variable value for the end date.

 

  • Check to see if the X-axis format is set to Date/Time and the input format is recognized correctly, impose a filter where the X-axis is filtered to show data on or after the variable value for the start date and on or before the variable value for the end date.

 

  • Put a hidden data with the following formula BETWEEN( DATE( @B:B,”yyyyMMdd”), $start, $end ) and apply the filter action to select the “True” cases.

 

  • All of the above

 

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?

By

 

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?

 

  • A) MAP/MAPFLAT

 

  • B) IF

 

  • C) DATASOURCE

 

  • D) LOOKUP

 

  • E) None of the above

 

If a Klipfolio partner wants to build a template Facebook dashboard, import to his client accounts and have it show their specific Facebook data, is this the correct order of operations for the import procedure? 1. Create the custom company properties first 2. Set their valid values 3. Import the dashboard

By

 

If a Klipfolio partner wants to build a template Facebook dashboard, import to his client accounts and have it show their specific Facebook data, is this the correct order of operations for the import procedure?

 

1. Create the custom company properties first

2. Set their valid values

3. Import the dashboard

 

  • True

 

  • False