Please i need help I have column in my data base which have some repeated attributes as column base i want to count number of repeated attributes in the same column for example i have column name “Code” which contain many codes Code Column Repeated code GD122545 1 GD44541…

Question 1 You need to change that join from a Right join to a Left join to include all Deals even those without a matching order. You may also consider using a Full other join if you want to include non-matching rows from both tables Question 2 You can use a top and bottom filter in the analysis…

You can add a calculated field using the countOver function as follows: countOver({Code}, [{Code}], PRE_AGG) You can read more about level-aware aggregations such as countOver here Using Level-Aware Aggregations - Amazon QuickSight

thanks darcoli for fast reponse i tried countover function as you recommended but it gives me blank value in the new calculated field!! note: Code column is string type is this the problem?

Thanks darcoli for your support :heart_eyes:

I have another issue if you can support me i have 2 tables that i should connect together to get my analysis first table is constructed according to each order “Order_id” column so each row has a unique Order_id number and other columns containe order details like revenue, refund etc… the second …

If I understand correctly, the main issue here is that you have a dimension table that also contains aggregated data and then you are joining this with a metrics table. Each aggregated value will be repeated for each row in the metric table so the final sum of values will be the multiple of the orig…

Hi darcoli. can i ask for help please Question 1 I have 2 tables connected together [aws] Table 1 include all store deals codes Table 2 include all orders generated 2 tables is connected together through column Deal_Code_id in my analysis phase i can only see deal codes that have orders gen…

Question 2 How can i display only top 10 values in the chart?

Count attributes in same column

Q&A

darcoli December 16, 2021, 10:17am 4

for reference, this was solved here Count string item in same column

Topic		Replies	Views
Count string item in same column Q&A quick-sight , calculations	8	1806	December 16, 2021
Get count where number of occurrences = N Q&A quick-sight , calculations	20	2194	December 5, 2022
Aggregate count of child items creates cartesian join Q&A quick-sight , dataset , calculations , Business-Intelligence-Engineer	6	36	October 24, 2024
distinct_count/distinctCountOver alternative Q&A data-source , error , quick-sight , calculations , Business-Intelligence-Engineer	3	97	December 27, 2024
Calculation of value only once Q&A quick-sight , dashboards , business-user	14	183	August 2, 2025

Count attributes in same column

Related topics