Jump to content

Combination Chart Two Data Types (Integer and TimeSpan)


April Steele
Go to solution Solved by Bruno,

Recommended Posts

I need to do a combo chart where I have volumes on one side of the Y Axes (integer) and Turn Around Time (TimeSpan-in hours and minutes) on the other Y Axes (see attached example in excel). I keep getting an error because they are not the same data types. Is there a workaround for this?VolumenandTATComboChartExample.PNG.e2867842f407b50a41cf181433c55073.PNG

Link to comment
Share on other sites

@Gaia Paolini I did that and it worked but I want the display to be in hours and minutes. When I do the it as an integer it makes for example 2 hr 56 minutes (row 8 in the new attached) as an integer in minutes it would be 176.63 minutes. I need to show it by hours minutes because I don't want them to have to convert it to hours minutes which is how they are use to seeing the times. 

 

@David Boot-Olazabal I updated the data set to show exactly what I am needing. The format on the prior wasn't correct.

Data Set for Combo Chart Updated.xlsx

Link to comment
Share on other sites

Hi April,

Thank you for the provided excel sheet. That makes a easier to see what Spotfire should be doing.
I don't think you will be able to add this 'time' variable with the number of cases. I have tried to mimic your pivot table in Spotfire, but the average TAT isn't possible in Spotfire (the average isn't showing for the TAT column when pivoting).
And as the combination of time and categorical variables are not a match for the y-axis, you may have to display the data a bit differently. For instance, setting TAT on the x-axis and color the bars by month would give you this:
image.thumb.png.63403d29aa2a0d1e6f7cd3d07e95f0d3.png

Other visualizations may do as well, but that probably defies the initial idea.

What you always can do, as your preferred option isn't possible, is to file an enhancement request via https://ideas.spotfire.com. There is already one that looks what you need, so you may want to vote that one up: https://ideas.spotfire.com/ideas/TS-I-8525.

Kind regards,

David

Link to comment
Share on other sites

  • Solution

Hi,
In my opinion, it is possible with some creativity. I had the same issues/requirements in the past. My solution was to convert the timespan to an ‘integer’ that resembles the timespan, and after that, I could use it. By using the formatting options, it looks like a timespan.
image.thumb.png.0a1c81be19380a64bb1d40413801b10e.png

maybe it helps
regards
Bruno

  • Like 2
  • Thanks 2
Link to comment
Share on other sites

Thanks Bruno,

I had to add a final custom expression to get rid of the AM postfix in the integer of column3. As my colleague Gaia did see the line immediately, this could be due to my Spotfire version (14.4 HF3). But once that was done, I can see the line in the combo chart!

image.thumb.png.c6c64cbcaf59d55ad7b1aaf5b1853d9f.png

Thank you for sharing your solution! Very helpful.

Kind regards,

David

  • Like 2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...