Hi Mike, I don't know if there's a way to get what you want while preventing each record from having its own slice, but you can make it look like all the records for a given status are in the same piece of pie:
To do this, just change the [Status] pill to be treated as Dimensions instead of treating them as attributes. Right-click the pill in the marks card to do that.
The reason you probably won't be able to get rid of the individual slices is that your time difference is a table calc that requires the records to be in the level of detail. However, if you could edit this data source so that each record has a start and end time marked, you could avoid this.
Hi David Li,
Thanks for your reply! I tried your method of grouping the records. however, like you said it still distincts each record as a slice, and the size of the slice is based on the amount of records, not the amount of hours. I did try something else to at least get the information i want. I made a new calculation with an IF statement:
IF [Status]='ms:4' then 'Status 1'
ELSEIF [Status]='ms:3' then 'Status 2'
ELSEIF [Status]='ms:2' then 'Status 3'
ELSEIF [Status]='ms:9999' then 'Status 4'
What this does, it basically groups the records together. If this calculation is added to the dashboard, it shows me the amount of hours + together with the summary the percentage. One thing to add is that it has to be ignored in table calculations, because it needs the timeline of the first sheet. If it is not ignored, it will generate a timeline only based on the records in the same group, which means it will show incorrect times.
The summary shows what i want (amount of hours + percentage of total). Next step will be how to properly visualize this.