Avoid grouping in Pie or Donut chart

[Anonymous]

Hi,

I have a requirement as "I have 10 rooms as Room A, Room B, Room C etc., based on the time a person in a room, I need to calculate the time that he spent in one room and show this data in a visual as order by the time he entered into the room". I tried to bring this in pie/donut chart but it is not working. When I say not working it is actually grouping based on the room. If a person enters Room A  and spent 10 mins first and then Room B spent 2 mins and then Room C spent a min and then again the went back to Room A and spent 5 mins and then went to Room D and spent 15 mins, the chart should show in this order instead of showing the total time spent in Room A and Room B and Room C.

Location	TimeEntered	Timespent in mins
Room A	23-03-18 11:03	8
Room B	23-03-18 11:11	1
Room C	23-03-18 11:12	2
Room D	23-03-18 11:14	1
Room E	23-03-18 11:15	5
Room B	23-03-18 11:20	6
Room A	23-03-18 11:26	10
Room C	23-03-18 11:36	5
Room B	23-03-18 11:41	8
Room F	23-03-18 11:49	3
Room G	23-03-18 11:52	1

like this, it is grouping one area irrespective of time order and room.

 

I want something like this in order and Room should show in single color

Can someone please help me to get this? Also please suggest if any other will suit for my requirement.

Thanks

Akhil

[Zubair_Muhammad · Accepted solution]

@Anonymous

See the file attached file with your sample data

First add these calculated columns in your Table

New Location =
Table1[Location] & Table1[TimeEntered]

RANK =
RANKX ( Table1, Table1[TimeEntered],, ASC, DENSE )

[Greg_Deckler]

Well, perhaps you could create a new column that concatenates Location and Time Entered and then try to set the Sort By on this new column to Time Entered. You would probably have to do that concatenation in the query however to avoid a circular reference. That being said, I have no idea if a pie chart has any concept of sorting.

[Anonymous]

Hi @Greg_Deckler,

Sorry, I didn't get your point. Can you please explain more in detail?

Thanks

[Zubair_Muhammad · Accepted solution]

@Anonymous

See the file attached file with your sample data

First add these calculated columns in your Table

New Location =
Table1[Location] & Table1[TimeEntered]

RANK =
RANKX ( Table1, Table1[TimeEntered],, ASC, DENSE )

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

Now drag the New location and RANK fields to LEGEND

and Timespent in minutes to VALUES

AND RANK to Tooltips

Now sort by RANK Column

[Anonymous]

Thanks, @Zubair_Muhammad. It works 🙂