Keep Line+Bar format even when Null or Zero

Sweep_The_Leg
Sweep_The_Leg Member
in Charting

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 Coach
    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 ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    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 ❤️ 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.

Categories