k-Means: The Excel writer doesnt't export the coverage

[Michel777]

Hi,

the Excel writer doesn’t export the coverage. How to get coverage into the export ?

Thanks,

Michel

[AlexanderFillbrunn]

Hi,
What do you mean by coverage? The cluster assigned to a data point? Can you show us your workflow?
Kind regards,
Alexander

[Michel777]

Hi Alexander,

thansk for your response !

“coverage” = Count of cases in a cluster is not included in the Excel export.

Warm regards,

Michel

[AlexanderFillbrunn]

Hi,
It’s not in the output as a table directly, but you can easily add it. You can just use a GroupBy node with the topmost output of the k-Means node and group by the cluster column. In the “manual aggregation” tab, you can choose any other column to aggregate and as aggregation method, choose “Count” (in the table on the right side). The resulting table contains your coverage and you can write it to your Excel file as well. By the way: if you want to write everything into the same Excel file as separate sheets, you do not need multiple Excel Writers. Instead, you can click the three dots on the Excel Writer and add more table input ports. Each input will end up in one sheet.
Kind regards,
Alexander

[Michel777]

Hi Alexander,

thanks lot for your help, for your time ! You can not imagine how much you helped me !

Warm regards,

Michel