Forum Discussion

rmieszko's avatar
rmieszko
Frequent Visitor
7 years ago

Combined chart with two X-axis

Hello,   I have a table with tickets reported in our system. Each ticket has columns: ID, Reported Date, Closed Date, Close Reason. I'd like to draw a chart, where I can see: X-axis: Month numbe...
Need Help
rmieszko's avatar
rmieszko
Frequent Visitor
7 years ago

Any idea, anybody? :-)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi rmieszko,

    The way I have done is,

    1. Create a Calendar Table (Date Dimension).

    2. Using Calculate table create another table by filtering out only the resolved tickets.

    3. Join the Original table with all tickets on Reported Date with the Date Dimension.

    4. Join the calculated table with only resolved tickets on Resolved Date with the Date Dimension.

    5. You can then create a single chart with both reported tickets count & resolved tickets count.

     

    Please let me know if this resolves your issue or if you would like me to explain further.

     

    #KeerthanUpadhya.