Keep Line+Bar format even when Null or Zero

I have a line+Bar chart, line is a target and the bars are each department (3 segments in each bar). problem occurs when I filter for any specific department, the bars collapse because there's no data for that specific department within that month. How do I keep the integrity of 6 segment and 2 bars even when there's no value?

 

 

Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Answer ✓

    you would have to have a row for each department for each month.

    You can create a template dataset that has one row for each department with a fixed amount of 0, then UNION that to your actual dataset.


    Jae Wilson
    Check out my Domo Training YouTube Channel

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.