Extra 0 bar in bar chart with beast mode

rupinderkaur87
rupinderkaur87 Member
in Charting

I have (using Beast mode )created 11categories in vertical bar graph card ,

image.png

but in the it shows up with extra '0" bar

image.png

How can i delete this extra 0 bar?

Best Answer

  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    Hi @rupinderkaur87,

    First, you have to Unpivot in ETL. Then It should work with a simple COUNT. Here is the same table:

    image.png

    Dynamic Unpivot in ETL:

    image.png

    Result table:

    image.png

    Bar chart:

    image.png

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

Answers

  • GrantSmith
    GrantSmith Coach

    This is because your beast mode is returning NULL for some records (where none of the conditions are met). You can filter out the NULLs and it will remove it from the chart.

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

    @GrantSmith , Thanks for the help.

  • rupinderkaur87
    rupinderkaur87 Member

    For data like this :

    image.png

    The vertical bar chart required is : each bar giving count of column categories , tried with calculated fields but cannot get desired answer

    image.png
  • Manasi_Panov
    Manasi_Panov Contributor
    Answer ✓

    Hi @rupinderkaur87,

    First, you have to Unpivot in ETL. Then It should work with a simple COUNT. Here is the same table:

    image.png

    Dynamic Unpivot in ETL:

    image.png

    Result table:

    image.png

    Bar chart:

    image.png

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

  • rupinderkaur87
    rupinderkaur87 Member

    Hi @Manasi_Panov , the suggested solution worked for this problem, thanks you so much.

Categories