Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to plot 2 date series in a single histogram

Hello,  I was hoping you could help with the following. I have 2 columns called "Case Open" and "Case Closed" showing when each case was open and closed. I'd like to plot these 2 date series in a si...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

HI, Anonymous

After my test, you may try this way as below:

In Edit Queries, select Case Open column and Case Closed column then click Transform->Unpivot columns

BeforeAfter

Then close&Apply

and darg new field value as X-axis, and Attribute field as legend

 

Best Regards,
Lin

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you. I'm not sure your solution would work in my case since my table is made up of 30+ columns with thousands of rows, one row each case.

I have several other visuals already setup that read from the other colums. With your solution I would effectively double the number of rows just for 1 column, and although the histogram would work, I would think all the other visuals will stop function the way they should?

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous

    For Case Open and Case Closed are two columns and put them together. it is bound to twice the size of the dataset.

    and you could do these for the histogram visual and other visuals

    Step1:

    In the Edit Queries, duplicate basic table and then Unpivot columns for the duplicate table

    Step2:

    Create a relationship between the basic table with duplicate table ( optional )

    Step3:

    Use duplicate table only to create the histogram visual and basic table to create other visuals.

     

     

    Best Regards,
    Lin