8 Replies Latest reply on Aug 12, 2016 3:54 AM by Tony Bradshaw

# Recognizing Discreet Data as Continuous Time Across Days

I am sure the question alone will highlight how new I am to Tableau, so I won't say.

I have a set of data that has a lot of manufacturing type of Measures - pressure, flow, temperature, etc. - the data is by Day and then Morning and Night.  Morning and Night are not real times of day, and are presenting basically a discreet lump of data during that period.  But I would like to graph the data day-by-day, morning to night each day, as a line graph.

I can convert my Day field to a date and make it continous and recognized as such, but I can't seem to find a straight forward way of making mornings come before nights each day and getting the lines to connect (literally) across the days.

• ###### 1. Re: Recognizing Discreet Data as Continuous Time Across Days

Hi Tony,

Can u share sample work book or data source. so that i can try and update the same.

Thanks

• ###### 2. Re: Recognizing Discreet Data as Continuous Time Across Days

Hi Anand,

Here is a simple sample version of data in Excel along with a look at how I would like the data to be represented and the way I am only able to get it to show in Tableau so far.

Thanks for any help!

• ###### 3. Re: Recognizing Discreet Data as Continuous Time Across Days

Hi Tony,

No attachment..

• ###### 4. Re: Recognizing Discreet Data as Continuous Time Across Days

Hi Tony.

Frankly, not sure if you are going to get exactly the same results out of Tableau that you did with Excel.

However, we can examine the question from another angle.  Basically you want to cohort values out by either the 'shift' or 'temp vs. pressure', right?

I imagine you have questions like "Why are my pressures lower in the night and by how much?"

So then you can consider this a cohort problem.

You could cohort out by 'Shift' by place the dimension shift on the Row shelf. That's easy, no calculated fields or dual axis charts needed.

Or you could create a few cohort calcs and compare the same function (pressure or temp) by the same 'shift'. (\Probably closer to what you want if my guess about the nature of your questions is close).

Examine the attached workbook to reverse engineer.

Steve Burger

• ###### 5. Re: Recognizing Discreet Data as Continuous Time Across Days

Steve,

I am interested in the 'cohert' methodogy for some of my data, and I was able to create similar presentations in Tableau already - thank you.  But for a lot of my data in this particular case, I just need to show a time-series output simply for someone else to follow the plan, not really for analysis purposes.  But I do want to keep all the material together [in Tableau].

I have not had time to try it yet, but if there is no obvious way to have Tableau recognize the Morning-Night pattern, then I was going to somehow create a generic 'time' that each Morning got (say 08:00) via a lookup perhaps, and similar with Night (say 21:00), and figure then it would be easier to link the dimension as date/time to the day and thereby have them follow one another.

Certainly not elegant, but an idea.

• ###### 6. Re: Recognizing Discreet Data as Continuous Time Across Days

Trying again to attach.  I could see the attachment in my view.

• ###### 7. Re: Recognizing Discreet Data as Continuous Time Across Days

Hi Tony,

Think your idea of a continuous date/time field is going to get you closest to the existing chart in your Excel file, I've attached an idea on how I'd go about this in case it helps...

Michelle

• ###### 8. Re: Recognizing Discreet Data as Continuous Time Across Days

Michelle,

Thank you for your thought and example.  Unfortunately, I am waiting for our IS team to push version 9.3 to me, so cannot open.