Suggestions on building a certain Bar Graph in New UX Page

Options
neg177
neg177 Member, ALL USERS, Community Member Posts: 5
in Anaplan Community

Hi, 

I would like advise on how to build a certain view of a Bar Graph in the new UX Page. I have had trouble trying to build an image of this graph down below. I was able to do this as two separate Pie Chart's, yet not able to do so as a Bar Graph. Please advise on how to replicate this as a Bar Graph. 

neg177_0-1663266576097.png

Pie Chart Version

neg177_1-1663266688196.png

 

 

 

Thank you, 

 

Nora Elizabeth Graham

 

Tagged:

Comments

  • anand.shekhawat
    anand.shekhawat Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Valued Contributor

    Hi @neg177 

     

    This is quite possible in two different Column charts. Follow the below steps

    1) Create a module with 4 line items as CA, NY, VA & Bankruptcy

    2) Fetch the required numbers for the respective months/years, I have taken few random numbers below

    anandshekhawat_0-1663273584333.png

     

    3) Create a Column chart on the NUX by using the module with below pivot format

    anandshekhawat_1-1663273667901.png

    4) Don't forget to select the chart type to 'Column' from the overview section.

    anandshekhawat_4-1663274026664.png

     

    5) Now check the radio button on Stacked

    anandshekhawat_2-1663273811619.png

     

    6) You would get the chart somewhat like below

    anandshekhawat_3-1663273869250.png

    This could be your Collections or Expenses depending upon your calculations.

    There would be two different charts. It would be difficult to bring both Collections and Expenses in the same view/chart

     

    I hope it helps

     

    ~Anand

     

Categories