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?

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

Leave a Comment