Grouping rows

[Springmoon]

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

Issue #

1

2

2a

2b

3

4

4a

4b

4c

5

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?

[VesaLukka]

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;

[williejacobs]

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.