Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How to aggregate data without using data of filtering dimension

Avatar

Avatar
Level 1
Terry25
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
Terry25
Level 1

Likes

0 likes

Total Posts

14 posts

Correct Reply

0 solutions
View profile
Terry25
Level 1

18-05-2020

Hi All,

 

i forgot how to aggregate data from a table without using data of the filtering dimension or creating a link.

 

indeed, I have a data schema “orders” with a list of orders ( order date, order id, customer id, item, price) and i want to transform (pivot) that table at customer id in order to have the number of items ordered per customer) : I do not want to use the method by going first to the “customer” data shema in the query and adding data 

 

Thanks in advance for your answers,

Terry

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

18-05-2020

Hi,

 

If the join cardinality is 'multiple' on the schema, you should be presented with a wizard to configure the pivot in the select part of the query, e.g. how many rows to pivot into cols.

If the link isn't defined in schema, the same can be done with an enrichment.

For filtering, no pivot is necessary- just use a filtering dimension or an exists clause.

 

Thanks,

-Jon

Answers (0)