Room Count by Name and export it to Excel

Revit
,
1

Dear all Guys, Master of Dynamo

I am a newbie and I want to count rooms by Name parameter.
But I got a result that it was only count how many “Name”, however I want to get how many rooms for each Names.
This topic has been solved like in this link below

http://dynamobim.org/forums/topic/count-items-with-the-same-value/

But I didn’t get the same result. What is the problem, I don’t understand.

Room Count
Room Count.PNG1402×719 169 KB

I have more way to go after I have the result, I want dynamo to export each name count to excel.

I learn how to export data from dynamo to excel, but I don’t know how to connect room count by name result to input write to excel nodes.

Room Count by Name and export to excel
Room Count by Name and export to excel.PNG1706×870 59.3 KB

If you have an answer that would be great because this will save my time in office.

Thanks before

Dynamo v 1.3 on Revit 2016
.Dynamo_Room_Count_Write_to_Excel.dyn (17.4 KB)

2

Try to change the level on your List.Count node to see if it helps. You will find related info on this page (see List@Level) or here also.

3

You can also set the lcig to longest here. Once you have done that use a List.Create node with the unique keys as the first input, then the results of the list.count node as the second. List.Transpose to set the list to what I think will be your desired format. Make sure overwrite is on or you may have some bad artifacts left over in your data.

4

Thanks Guys, my first dynamo works great… hehe… Now I’ll try to write it to excel.
I add design option filter because it’s necessary on preliminary stage.

image
image.jpg1688×882 436 KB

5

This has been solved! Thanks @Scott_Crichton