How to show series of dates not closely tied to your data point?

Gee_Escuadro
Gee_Escuadro Member
in Beast Mode

Is there a way to show a series of dates in sequential order (either daily, weekly, monthly, etc.) without the date being closely tied to a particular data point? 

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    There's a calendar card-type, if you just want a list of dates.

    But my guess is you're charting some data that has gaps in which dates there is data for, and you'd like those gaps to be maintained or shown with labels in whatever chart/table you're working on. The answer to that is, no, you can't graph data that isn't in your dataset. You need a row with that date and a null value for what you're graphing, plus a value that matches anything you're filtering on. You can get that by joining your data with Domo's calendar dataset. You might search through past community forum posts to find something that best matches your situation, because this is a question that has been asked/answered a fair number of times in different iterations. Here's one with a particularly thorough explanation from @MarkSnodgrass:

    https://community-forums.domo.com/main/discussion/comment/89713#Comment_89713

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    There's a calendar card-type, if you just want a list of dates.

    But my guess is you're charting some data that has gaps in which dates there is data for, and you'd like those gaps to be maintained or shown with labels in whatever chart/table you're working on. The answer to that is, no, you can't graph data that isn't in your dataset. You need a row with that date and a null value for what you're graphing, plus a value that matches anything you're filtering on. You can get that by joining your data with Domo's calendar dataset. You might search through past community forum posts to find something that best matches your situation, because this is a question that has been asked/answered a fair number of times in different iterations. Here's one with a particularly thorough explanation from @MarkSnodgrass:

    https://community-forums.domo.com/main/discussion/comment/89713#Comment_89713

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • Gee_Escuadro
    Gee_Escuadro Member
    edited September 22

    Thank you 😊

  • MarkSnodgrass
    MarkSnodgrass Coach

    Here is the video that is referenced in the earlier post.

    https://youtu.be/9iNpzSL5V6U?si=cVZcx_dmTMfTHjXs

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories