# Combine two datasets

**URL:** <https://forum.inductiveautomation.com/t/combine-two-datasets/45855>\
**Category:** Ignition\
**Created:** [April 21, 2021, 10:24am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855 "2021-04-21T10:24:03Z")\
**Posts on this page:** 20\
**Page:** 3

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 6:50am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/43 "2021-04-23T06:50:51Z")

</div>

can you draw me on paper or paint or something what you/your boss actually wants?

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 6:55am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/44 "2021-04-23T06:55:18Z")

</div>

because i think you and your boss are talking about a diffrent kind of offset. Or me idk

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 6:59am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/45 "2021-04-23T06:59:15Z")

</div>

![Untitled](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/3/e3e418452b90a9eff4afad06a18c283ba57dd530.png)

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:01am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/46 "2021-04-23T07:01:52Z")

</div>

simple when i choose first tag . i am selecting time 4am to 5am. it will show data for that

if i select another tag i want to show data from 4.05am to 4.50 am

some difference between the first and second tag

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:01am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/47 "2021-04-23T07:01:55Z")

</div>

So the offset is on the time?

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:02am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/48 "2021-04-23T07:02:08Z")

</div>

yes correct. because time stamp column will be same for all tags so

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:04am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/49 "2021-04-23T07:04:44Z")

</div>

**dataSet1** = system.tag.queryTagHistory(paths=[‘Sine’], startDate= **startTime1** , endDate= **endTime1** , returnSize=1, aggregationMode=“Maximum”, returnFormat=‘Wide’)

**dataSet2** = system.tag.queryTagHistory(paths=[‘Sine’], startDate= **startTime2** , endDate= **endTime2** , returnSize=1, aggregationMode=“Maximum”, returnFormat=‘Wide’)

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:05am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/50 "2021-04-23T07:05:12Z")

</div>

Just change the times when you collect the dataset?

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:06am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/51 "2021-04-23T07:06:17Z")

</div>

same thing i am doing. but when join dataset1 and dataset2 in to single dataset. i am getting this type of issue

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:06am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/52 "2021-04-23T07:06:51Z")

</div>

yes collecting but i am to show them in single dataset not in different dataset

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:07am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/53 "2021-04-23T07:07:12Z")

</div>

define “this type of issue”

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:08am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/54 "2021-04-23T07:08:06Z")

</div>

![normal chart](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/f/1f00c582a6b4570934eeb41bdcc105d13668ab45.png)

like this

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:08am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/55 "2021-04-23T07:08:38Z")

</div>

is the issue the blue line being so flat or the red line having holes?

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:09am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/56 "2021-04-23T07:09:56Z")

</div>

holes in both red and bule see.  
some space

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:11am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/57 "2021-04-23T07:11:01Z")

</div>

which chart are you using? in vision or perspective?

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:12am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/58 "2021-04-23T07:12:01Z")

</div>

in vision. normal chart

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:20am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/59 "2021-04-23T07:20:21Z")

</div>

vision has a chart customiser.  
I suppose you need  
Dataset Properties Tab:

| Renderer | XY Line/Shape Render |
| --- | --- |
| Type | Lines Only |

you can look here i suppose you want something like the date axis chart example  
[https://docs.inductiveautomation.com/display/DOC81/Vision+-+Chart+Customizer](https://docs.inductiveautomation.com/display/DOC81/Vision+-+Chart+Customizer)

if that doesnt work you should probably make a new topic

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:38am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/60 "2021-04-23T07:38:31Z")

</div>

> [@victordcq](#):
>
> ||XY Line/Shape Render

Actually i am using this only XY Line/Shape Render  
same type Line only

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [April 23, 2021, 7:45am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/61 "2021-04-23T07:45:40Z")

</div>

i suppose its having some trouble with the null’s that have been added in  
you should make a new topic. Im not familiar enough with vision charts.

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [April 23, 2021, 7:48am UTC](https://forum.inductiveautomation.com/t/combine-two-datasets/45855/62 "2021-04-23T07:48:34Z")

</div>

Ok thanks for the time

[Previous page](https://forum.inductiveautomation.com/t/combine-two-datasets/45855.md?page=2)

[Next page](https://forum.inductiveautomation.com/t/combine-two-datasets/45855.md?page=4)