Graph is only showing 11 months of data for 12 months

Patricia_Zavisky
Patricia_Zavisky Member
in Charting

Hi, I would like to show 12 months of data but because there is not data in December 2023 the month is not showing. I have selected Fill missing spaces which only works if I select for e.g. Nov 2023 then Dec 2023 column appears. How do I fix?

image.png

Best Answer

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    Hello @Patricia_Zavisky,

    Join your dataset with Domo Dimensions Connector from the Appstore to add rows for each month/year, even if the value is 0. Replace nulls with 0 either in ETL or by using Domo Beast Mode with a formula like:

    CASE WHEN IFNULL('your_column', 0) = 0 THEN 0 ELSE 'your_column' END

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

Answers

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    Hello @Patricia_Zavisky,

    Join your dataset with Domo Dimensions Connector from the Appstore to add rows for each month/year, even if the value is 0. Replace nulls with 0 either in ETL or by using Domo Beast Mode with a formula like:

    CASE WHEN IFNULL('your_column', 0) = 0 THEN 0 ELSE 'your_column' END

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

Categories