Jump to content

SSRS daahboard transition to Spotfire environment


Anusha V

Recommended Posts

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

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

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

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...