Group by using calculated field

Question & Answer
, ,
1

I would like to know if I can group elements by index and companyid taking the maximum element from the weightqualified column

2

Hi @Joanne

thank you for your question. I guess a Level Aware Calculation might help you.
Can specify the input table structrue and your desired output a bit more?

Regards,
Nico

1 Like
3

I have columns that are very important companyId, bdr, stagename, Peso, index.
I would like to group by companyId, stageName and idex.
Consider the smallest index in the grouping when counting this line in quicksight and consider the minimum weight

4

Hi @Joanne ,

does your data look like this?
image

1 Like
5

Do you have a measure called wieght? If yes: does this helps you?

min({weight}, [{companyId}, {stageName}, {index}])

Regards,
Nico

2 Likes
6

Iā€™m going to clarify my doubt, I want to consider in my analyzes in Quicksight the first items registered in the dataset combining companyid and stagename, I can use the querydata field to check which item was registered first.
I would like to create a calculated field for this.

7

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena