I have created benchmarks KPI by using SUMOVER calculated fields, in order to compare a brand to all the other brands in the same industry and country.
Whenever I select a brand using Control Filters, the below table (see screenshot) should be able to tell me how all the other brands belonging to the same industry (and country) are performing. To do so I have used SUMOVER for all metrics (clicks, impressions etc).
The problem is that with the amount of data, often the table fails to load.
Could you suggest an altrnative?
sumOver(Clicks, [{industry}, country], PRE_FILTER)
@Patrizia_Buompastore - Thanks you for posting your query. Can you please tell if you are using SPICE based datasets or Direct Query? Thanks!
1 Like
Hi there, I am using SPICE
Hi @Patrizia_Buompastore ,
Thank you for letting us know. Since this is an issue that is closely related to the data types and data volume in your dataset, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!
Regards,
Arun Santhosh
1 Like