Forum Discussion

ScripTeapot_'s avatar
ScripTeapot_
Frequent Visitor
3 years ago
Solved

Need help or guidance to visualice data

English is not my first language so I'm sorry.

Here's what I'm trying to do and my first solution to it; I need to visualice two amounts of money: a planned amount and a real amount to see whats de difference between them, also I need the accumulative amount month per month; if feb. is 100 dollars and march is 200 then I need to visualice the money paid in march plus de money paid in feb. like a stacked pile. My solution to this is a combined chart where the real money are stacked bars and the planned money is a line. I don't know if this is the best solution to this problem, but in any case, I need a little bit of guide.

1 Reply

  • Hi ScripTeapot_ ,

     

    Based on your description, I have created a simple sample:

    Please try:

    First create a date table:

     

    Then manage relationship:

    Then create the visual:

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.