How do I get the date to show up even when there are no results?

Currently, as shown in the following figure, there is no indication after the week of 3rd July. This is due to the lack of results.

How can I display after the week of 3rd July?


Best Answer

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    Start with the calendar dataset from the Domo date dimension connector and left join your dataset to it on the date using a dataset view or ETL. Then use the calendars date field instead of your own. Left join will cause your missing data to be null but still have the dates from the calendar

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith

    Thank you for your response!

    We were restricted from getting the Domo Dimensions Connector, so I'll check in-house first!

  • GrantSmith

    The Domo date dimension connector was not available due to its disallowed use within the company.

    However, by creating the calendar dataset in Google spreadsheet and then "Append Rows" using ETL, we were able to achieve what we wanted.

    Thank you very much for your help.