Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Plotting 2 Dates on X axis - Time Series graph

Hello,   I am having issues getting two dates (planned dates for functional testing software v. actual executed date of testing software) to plot on the same x-axis of a line graph. I want to be ab...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

I have a little confused about your requirement.

Do you want both of the two dates on the same x-axis in the line chart? And the two dates from the different table?

Namely, do you want the x-axis dynamically change based on the name of the tester slicer?

If it is convenient, could you share the data sample which could reproduce the scenario as table format so that I could have a test on it?

Best Regards,

Cherry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi @v-piga-msft

     

    Sorry yes - I would like both dates on the same X-axis, I manually created the two date tables ("Planned Date" and "Executed Date") and populated them with data from the original table, but I don't know if that needs to be done at all, perhaps I can just use the original table.

     

    Essentially I just need the "System Cycle 1 Execution Date" column and the "Planned Execution Date" column from the original "Test Scenarios" table to be plotted on the same X axis and then for the "Tester" column to affect both dates when I filter on team member names to track individuals workload over time. Please let me know if this helps, I will need to receive approval to provide the raw data but will follow up if I can with that information.