How can I do a time series graph with several attributes in the y axis for several domain dimension?

Hi @santosj,

Can you share your dataset, please ?

Regards,

Lionel

Hi again @santosj,

1.Go to the Results windows (after running your process)

2. Go to the Charts Panel 

3. Select Series as Chart Style (if RapidMiner has not set automatically)

4. Set your Index Dimension (your time attibute) and Plot Series (the attribute you want to display in your chart). (Ctrtl + select the attribute you want to display).

Here the screenshot to help you : 

Hope it helps,

Regards,

Lionel

Thank you for your reply!

I, unfortunately, cannot share the data that I have but I send you a similar dataset to better convey my question.

In the attached Excel file you can see patients that have carried out a treatment to lower their blood pressure. What I would like to do is to plot these blood pressures in a time series graph for each time span on days (Date of the 2 months measurement - Treatment Date), (Date of the 3 months measurement - Treatment Date) and (Date of the 6 months measurement - Treatment Date) to see graphically if the patients improved after the treatment they have carried out to lower their blood pressure. I have already calculated these time spans in the Rapid Miner Platform with the attribute generator operator. I could also use as a domain graph the indication of "2 months", "3 months" and "6 months", that I do not know how to do it also, but I taught to use the time span because I would like to afterward add to the graph the standard deviations of the time span. 

Thank you 

Thank you for your help,

Unfortunately, my difficulty lays on the index because I need to represent the several time spans in days that I have mentioned before...Do you have any clue on how I could do it?

Thank you for your time, 

Hi again @santosj,

Interesting problem !

If I good understand, one way to perform what you want to do is to use the De-Pivot operator.

By using this operator, you obtain the Blood Pressure according to the time like this : 

and then you can plot these data like this : 

You can find the process here : 

<?xml version="1.0" encoding="UTF-8"?><process version="8.1.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="8.1.001" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="read_excel" compatibility="8.1.001" expanded="true" height="68" name="Read Excel" width="90" x="112" y="34">
        <parameter key="excel_file" value="C:\Users\Lionel\Documents\Formations_DataScience\Rapidminer\Tests_Rapidminer\Time_series_Plot\Time_series_Plot_Blood_pressure.xlsx"/>
        <parameter key="imported_cell_range" value="A1:I3"/>
        <parameter key="first_row_as_names" value="false"/>
        <list key="annotations">
          <parameter key="0" value="Name"/>
        </list>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="Patient ID.true.integer.attribute"/>
          <parameter key="1" value="Blood Pressure before treatment.true.integer.attribute"/>
          <parameter key="2" value="Blood Pressure 2 months.true.integer.attribute"/>
          <parameter key="3" value="Blood Pressure 3 months.true.integer.attribute"/>
          <parameter key="4" value="Blood Pressure 6 months.true.integer.attribute"/>
          <parameter key="5" value="Treatment date.true.date_time.attribute"/>
          <parameter key="6" value="date 2 months.true.date_time.attribute"/>
          <parameter key="7" value="date 3 months.true.date_time.attribute"/>
          <parameter key="8" value="date 6 months.true.date_time.attribute"/>
        </list>
      </operator>
      <operator activated="true" class="generate_attributes" compatibility="8.1.001" expanded="true" height="82" name="Generate Attributes" width="90" x="246" y="34">
        <list key="function_descriptions">
          <parameter key="2" value="2"/>
          <parameter key="3" value="3"/>
          <parameter key="6" value="6"/>
          <parameter key="0" value="0"/>
        </list>
      </operator>
      <operator activated="true" class="select_attributes" compatibility="8.1.001" expanded="true" height="82" name="Select Attributes" width="90" x="380" y="34">
        <parameter key="attribute_filter_type" value="subset"/>
        <parameter key="attributes" value="Blood Pressure 2 months|Blood Pressure 3 months|Blood Pressure 6 months|Blood Pressure before treatment|6|3|2|0"/>
      </operator>
      <operator activated="true" class="de_pivot" compatibility="8.1.001" expanded="true" height="82" name="De-Pivot" width="90" x="514" y="34">
        <list key="attribute_name">
          <parameter key="Blood Pressure" value="Blood Pressure 2 months|Blood Pressure 3 months|Blood Pressure 6 months|Blood Pressure before treatment"/>
        </list>
        <parameter key="index_attribute" value="Time"/>
        <parameter key="create_nominal_index" value="true"/>
      </operator>
      <connect from_op="Read Excel" from_port="output" to_op="Generate Attributes" to_port="example set input"/>
      <connect from_op="Generate Attributes" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
      <connect from_op="Select Attributes" from_port="example set output" to_op="De-Pivot" to_port="example set input"/>
      <connect from_op="De-Pivot" from_port="example set output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

and the Excel example set (from your partial dataset) here : 

https://drive.google.com/open?id=1ZKmTSpj_jHV1rtaxBBCgpgwCIF-zl4zP

I hope it helps,

Regards,

Lionel 

Wow! I am impressed!

It is exactly that. You solved my problem! I´ve already tested it and it works!

I am very grateful...Thank you very much!

Jud

You're welcome Jud.

Good luck for your master thesis project.

Regards,

Lionel