I've been able to create a chart which shows me the utilisation of a location by using FirstSortedValue. My problem is i now need to be able to display the second (and third and forth and so on) value.
The original data is an excel sheet with each row an individual of which we identify the location and also the time of entry to that location as well as the length of time in that location.
The idea is to ultimately create a chart which will show when the location is in use by placing all the occasions of use on one line per location.
This is what i have at the moment:
The Expression i have used is: FirstSortedValue(DISTINCT [Length of Time in Theatres],1,1) and then FirstSortedValue(DISTINCT Into_theatre_Time,1,1) as the bar offset definition.
Any ideas how to go about adding the other instances of area usage?
(for completeness the chart is a stacked bar chart rotated on its side).
and then changing that last 2 to a 3 and so on allows the bars to show but the gap between the sections isnt correct.
It look like this:
Now there should be some gaps between those sections (as the location can't be used continually) and certainly the Into_theatre_Time for the second (and subsequent) occasion is after the end of the previous [Length of Time in Theatres] time code.
If it's worked within a table but not within a chart it might be caused from the applied dimensions - means that the table is more granular as the chart. In this case you may need to apply an aggr-wrapping for your expression in the chart.
Further your approach looked a bit like a gantt chart and therefore the following might be useful in any way: