SSRS daahboard transition to Spotfire environment

[Anusha V]

Hi,

One of our dashboard is developed in SSRS earlier, now the same way we need to replicate in our Spotfire environment.

exiting Report : X-axis : Desk number

Y-axis : 0-24 hrs and Static.

Color by : Cie Name and vertical

Please find the attached raw data for reference please help me to resolve the issue

[Khushboo Rabadia]

You can something similar to this in scatter plot like below:

 

You can unpivot the datatable i.e. add transformation > Unpivot

2. Select Data > Transform data...

Added transformations

Transformation name: Unpivot

Columns to pass through:

Zone

Desk

Cie

CieName

Columns to transform:

startTime

endTime

Category column name: Category

Category column data type: String

Value column name: DateTime

Value column data type: Real

Empty values included: YesOnce data table is unpivoted, you can configure scatter plot as shown above. Special consideration to get above format - make marker size to 0 in size and use desk column in line connection. Increase line width to 6 (which is max)

[Anusha V]

Hi Kushboo,

Thanks for reply, but the main problem is start time and end time is actually time.. When we use start time and end time as a real data type in value column... When we plot the visualization the starting position of line is showing not correctly.

Ex: start time - 18:30 and end time : 21:00, value column scale is 0-24 and intervel is 1

In this scenario if we use time data type line will start exactly between at 18 and 19 intervel at half of the position.

But when we convert this to real it is starting at the 1/3rd of that intervel

To achieve this I have written calculated column like if my starttime is 18:30 consider it as 18:45 like that..

Am facing issue now is tooltip how to show.

And how to show labels as vertically. Please help