11 Replies Latest reply on Feb 3, 2017 6:01 AM by Cathy Schatzke

# How to create a continuous line when using a row with calculated field

I have a worksheet with a calculated field for the rows (HH:MM:SS) and a Week Number for the columns.  I have produced a line connecting my dots, but that line doesn't connect from Week to Week, it connects from high to low HH:MM:SS.  For example, Week 3 and Week 9 have the same values, and so the line goes from Week 3 to Week 9 and then back to Week 4.  Can someone tell me how I can connect the dots in order by week number?   Thanks!

I am adding another attachment that illustrates the sort that I put on the calculated field, based on the Week Begin Date field.  .

• ###### 1. Re: How to create a continuous line when using a row with calculated field

Hi Cathy

I'm not sure what do you want to achieve finally, but do you want this?

[dateparse]

dateparse("h:mm:ss",[Time])

Thanks,

Shin

• ###### 2. Re: How to create a continuous line when using a row with calculated field

Yes, that is what I was trying to accomplish.  I did get the continuous line to work (finally), but I need to add an axis label that would apply to the range of HH:MM:SS seen in the display.  Is this possible to do?

Thanks!

• ###### 3. Re: How to create a continuous line when using a row with calculated field

Create dual axis chart and set secondary as circle/text or something and add "Discrete" label on 2nd axis.

(Need  to change default date/time format on duplicated discrete fields as <<h:mm:ss>>

Thanks,

Shin

• ###### 4. Re: How to create a continuous line when using a row with calculated field

Thank you!  Will give this a try.

• ###### 5. Re: How to create a continuous line when using a row with calculated field

Hope it works.

You can reverse engineering my attached workbook.

thanks,

Shin

• ###### 6. Re: How to create a continuous line when using a row with calculated field

Shin,

After looking at this a little deeper, this solution really will not work for my worksheet.  The HH:MM:SS field that I am displaying on the continuous line did not originate from a date/time field.  It originated from a calculation (Web Session Completion Time (in seconds) divided by the number of Applications).  That calculation is performed at a Week level.   That result field was then parsed into an HH field, a MM field, and a SS field.  Then, the HH, MM, and SS fields were strung together to create the HH:MM:SS that you see on the continuous line.

What I was hoping to do is somehow create a left Axis label that would show the range of the HH:MM:SS fields on the continuous line.  (see attached image)   I am beginning to think that this is not possible.

Thanks,

Cathy

• ###### 7. Re: How to create a continuous line when using a row with calculated field

Hi Cathy,

I don't understand the difference from my workbook and your image.

Could you mock up your data as packaged workbook ?

It's pretty frustrating us to crate dummy data by ourselves.

That's really inefficient like this case.

Thanks,

Shin

• ###### 8. Re: How to create a continuous line when using a row with calculated field

I think you need to open the packaged workbook that you sent to me in your example above.  It is nothing like what I am trying to accomplish here.  The dashboard filter_SM_8.3 twbx package contains something entirely different.  I do agree that the picture above it containing the continuous line with HH:MM:SS is very similar to what I am trying to accomplish, although I do not have a date field from which I can parse the h:mm:ss.

• ###### 9. Re: How to create a continuous line when using a row with calculated field

Oh, I found that I attached wrong workbook.

Silly me!

I will find correct workbook and will attach it.

Thanks,

Shin

• ###### 10. Re: How to create a continuous line when using a row with calculated field

Here you go.

[Time Format]

dateparse("h:mm:ss",[Hmm])

Looks like better use "circle" than text when considering label position.

Thanks,

Shin

• ###### 11. Re: How to create a continuous line when using a row with calculated field

This answer is actually very close to what I want to do; however, my plotted circles on the continuous line represent minutes and seconds that it took to complete an activity.  Your left axis is showing a time of day that represents the minutes portion of the plotted numbers.

What I would like to do is show the range of minutes and seconds that are represented on the continuous line.  For instance, the left axis should look like this, where the top plotted circle is the value 0:49:05 (almost 0:50:24).   Values for the weeks for the blue line are as follows:

Week 3 – 0:45:38

Week 4 – 0:45:58

Week 5 – 0:48:52

Week 6 – 0:49:05

Week 7 – 0:46:23

Week 8 – 0:47:19

Week 9 – 0:45:37

Week 10-0:46:47

Etc.