Hi, new member to the forum here. Your help would be much appreciated.
I'm beginning to build a dynamic dashboard to show the current state and availability of system environments however I'm struggling with displaying the data in the correct format that I want from a pivot table and chart.
I have a list of environments with several variables. I’m trying to show if the environments are currently being used and if they are, when it becomes available to use again. I have a 'booked from' column and 'booked to' column and also a 'Duration' column which calculates the days from booked to end date.
I want a bar chart to show the Names of the environments down the y axis and months along the x axis to show when the use of environment finishes. However I have been trying to figure out how to show this for hours. Yes hours! It seemed pretty straight forward in my head but struggling to implement. I can’t seem to get the x axis to show the months. Note: I want the x axis date to start from earliest 'Booked from' date. Please see example of data below.
[TABLE="width: 1042"]
<tbody>[TR]
[TD][TABLE="width: 1042"]
<tbody>[TR]
[TD]Application
[/TD]
[TD]Environment
[/TD]
[TD]Type
[/TD]
[TD]Status
[/TD]
[TD]Project
[/TD]
[TD]Owner
[/TD]
[TD]Server Name
[/TD]
[TD]Database Name
[/TD]
[TD]Booked from
[/TD]
[TD]Booked until
[/TD]
[TD]Length
[/TD]
[/TR]
[TR]
[TD]Housing
[/TD]
[TD]HOULIVE
[/TD]
[TD]LIVE
[/TD]
[TD]In Use
[/TD]
[TD]BAU
[/TD]
[TD]Service Management
[/TD]
[TD]HSRV_1
[/TD]
[TD]HSRVDB_1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Dec-18
[/TD]
[TD]322
[/TD]
[/TR]
[TR]
[TD]Finance
[/TD]
[TD]HOULIVE
[/TD]
[TD]LIVE
[/TD]
[TD]In Use
[/TD]
[TD]BAU
[/TD]
[TD]Service Management
[/TD]
[TD]FSRV_1
[/TD]
[TD]FSRVDB_1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Dec-18
[/TD]
[TD]322
[/TD]
[/TR]
[TR]
[TD]Kirona
[/TD]
[TD]HOULIVE
[/TD]
[TD]LIVE
[/TD]
[TD]In Use
[/TD]
[TD]BAU
[/TD]
[TD]Service Management
[/TD]
[TD]KISRV_1
[/TD]
[TD]KISRVDB_1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Dec-18
[/TD]
[TD]322
[/TD]
[/TR]
[TR]
[TD]Housing
[/TD]
[TD]HOUDEV1
[/TD]
[TD]DEV
[/TD]
[TD]In Use
[/TD]
[TD]Asset
[/TD]
[TD]Joe Bloggs
[/TD]
[TD]HOUDE1VSRV
[/TD]
[TD]HOUDEV1DB
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Mar-18
[/TD]
[TD]47
[/TD]
[/TR]
[TR]
[TD]Housing
[/TD]
[TD]HOUDEV2
[/TD]
[TD]DEV
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]HOUDEV2SRV
[/TD]
[TD]HOUDEV2DB
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
[TR]
[TD]Finance
[/TD]
[TD]HOUDEV2
[/TD]
[TD]DEV
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]FDEV2SRV
[/TD]
[TD]FDEV2DB
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
[TR]
[TD]CRM
[/TD]
[TD]UAT1
[/TD]
[TD]TEST
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]UAT1SRV
[/TD]
[TD]UAT1DB1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
[TR]
[TD]Finance
[/TD]
[TD]UAT2
[/TD]
[TD]TEST
[/TD]
[TD]Free
[/TD]
[TD]Free
[/TD]
[TD]Free
[/TD]
[TD]UAT2SRV
[/TD]
[TD]UAT1DB1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]1-Feb-18
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]Qlikview
[/TD]
[TD]TRAIN1
[/TD]
[TD]TRAINING
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]TRAINSRV
[/TD]
[TD]TRAIN1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help or advice on how I can achieve this?
Thanks,
I'm beginning to build a dynamic dashboard to show the current state and availability of system environments however I'm struggling with displaying the data in the correct format that I want from a pivot table and chart.
I have a list of environments with several variables. I’m trying to show if the environments are currently being used and if they are, when it becomes available to use again. I have a 'booked from' column and 'booked to' column and also a 'Duration' column which calculates the days from booked to end date.
I want a bar chart to show the Names of the environments down the y axis and months along the x axis to show when the use of environment finishes. However I have been trying to figure out how to show this for hours. Yes hours! It seemed pretty straight forward in my head but struggling to implement. I can’t seem to get the x axis to show the months. Note: I want the x axis date to start from earliest 'Booked from' date. Please see example of data below.
[TABLE="width: 1042"]
<tbody>[TR]
[TD][TABLE="width: 1042"]
<tbody>[TR]
[TD]Application
[/TD]
[TD]Environment
[/TD]
[TD]Type
[/TD]
[TD]Status
[/TD]
[TD]Project
[/TD]
[TD]Owner
[/TD]
[TD]Server Name
[/TD]
[TD]Database Name
[/TD]
[TD]Booked from
[/TD]
[TD]Booked until
[/TD]
[TD]Length
[/TD]
[/TR]
[TR]
[TD]Housing
[/TD]
[TD]HOULIVE
[/TD]
[TD]LIVE
[/TD]
[TD]In Use
[/TD]
[TD]BAU
[/TD]
[TD]Service Management
[/TD]
[TD]HSRV_1
[/TD]
[TD]HSRVDB_1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Dec-18
[/TD]
[TD]322
[/TD]
[/TR]
[TR]
[TD]Finance
[/TD]
[TD]HOULIVE
[/TD]
[TD]LIVE
[/TD]
[TD]In Use
[/TD]
[TD]BAU
[/TD]
[TD]Service Management
[/TD]
[TD]FSRV_1
[/TD]
[TD]FSRVDB_1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Dec-18
[/TD]
[TD]322
[/TD]
[/TR]
[TR]
[TD]Kirona
[/TD]
[TD]HOULIVE
[/TD]
[TD]LIVE
[/TD]
[TD]In Use
[/TD]
[TD]BAU
[/TD]
[TD]Service Management
[/TD]
[TD]KISRV_1
[/TD]
[TD]KISRVDB_1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Dec-18
[/TD]
[TD]322
[/TD]
[/TR]
[TR]
[TD]Housing
[/TD]
[TD]HOUDEV1
[/TD]
[TD]DEV
[/TD]
[TD]In Use
[/TD]
[TD]Asset
[/TD]
[TD]Joe Bloggs
[/TD]
[TD]HOUDE1VSRV
[/TD]
[TD]HOUDEV1DB
[/TD]
[TD]1-Feb-18
[/TD]
[TD]20-Mar-18
[/TD]
[TD]47
[/TD]
[/TR]
[TR]
[TD]Housing
[/TD]
[TD]HOUDEV2
[/TD]
[TD]DEV
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]HOUDEV2SRV
[/TD]
[TD]HOUDEV2DB
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
[TR]
[TD]Finance
[/TD]
[TD]HOUDEV2
[/TD]
[TD]DEV
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]FDEV2SRV
[/TD]
[TD]FDEV2DB
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
[TR]
[TD]CRM
[/TD]
[TD]UAT1
[/TD]
[TD]TEST
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]UAT1SRV
[/TD]
[TD]UAT1DB1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
[TR]
[TD]Finance
[/TD]
[TD]UAT2
[/TD]
[TD]TEST
[/TD]
[TD]Free
[/TD]
[TD]Free
[/TD]
[TD]Free
[/TD]
[TD]UAT2SRV
[/TD]
[TD]UAT1DB1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]1-Feb-18
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]Qlikview
[/TD]
[TD]TRAIN1
[/TD]
[TD]TRAINING
[/TD]
[TD]In Use
[/TD]
[TD]CRM
[/TD]
[TD]Julie Smith
[/TD]
[TD]TRAINSRV
[/TD]
[TD]TRAIN1
[/TD]
[TD]1-Feb-18
[/TD]
[TD]10-Jun-18
[/TD]
[TD]129
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help or advice on how I can achieve this?
Thanks,