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? [UPDATED]

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? Question/Answer & Solution

  • Correct Answer : LOOKUP
  • kf:fill_elements
  • IF
  • ARRAY
  • GROUPBY

If you don’t know the answer for a certain Klipfolio Expert Certification Exam Question, use this simple cheat index to help you solve all the Klipfolio Expert Certification Exam Questions.

Use this page to find all Google Certifications Answers.
Contact us if you didn’t find the answer for a certain question. We will do our best to update our questions and answers asap.