topic Re: Grouping rows in Connectivity & Data Prep

Grouping rows

Springmoon — Tue, 09 Jul 2024 04:22:03 GMT

Hey everyone, I have a data set which has child/parent rows. For example

Issue #

And in some visualization I want to issue number as just parent row and in some I want to the whole count. It's easy to just group them in excel but how would I use that on my dashboard?

Re: Grouping rows

VesaLukka — Wed, 17 Jul 2024 10:40:15 GMT

In visulizations You can use dimension expression

=PurgeChar([Issue #], 'abcdefghijklmnopqrstuvwxyzåäö')

to use only parent Issues.

PurgeChar can allso be used in Data Load Editor:

Load [Issue #], PurgeChar([Issue #], 'abcdefghijklmnoprstuvwxyzåäö') as ParentIssue, PurgeChar([Issue #], '0123456789') as ChildIssue Resident OriginalTable;

Re: Grouping rows

williejacobs — Wed, 17 Jul 2024 11:14:17 GMT

Hi @Springmoon

I would suggest adding a field to check if the value is number.

Parent_Child:
Load *
,IsNum(Issue_#) as Num
Inline
[Issue_#
1
2
2a
2b
3
4
4a
4b
4c
5
];

You can then use this field to check if the value is Parent or Child.