I have data consisting of ids for properties/stores and IP addresses associated with surveys. I have a count calculated field. It’s just a count({survey_id}) that gets a count of all surveys but changes based on filters. I’ve created pivot table with the property_id and ip_address as rows, reponse_m…

Hi @jp207 , Are you trying to create a graph that shows survey count for each property id? If you remove the IP Address column from the pivot view you will be summarizing data at Property Id level and do you want to use that value for your chart/graph. It will be best if you can elaborate on your req…

@Karthik_Tharmarajan I have a filter setup that removes all counts that are less than one. However, because this just counts all surveys, what would happen when I remove the IP address column is that it will just filter for total survey counts per property instead of survey counts per property AND p…

@jp207 , I am not sure how you are calculating survery count but I just gave it a try with below sample data. I did not use LAC and was able to get the total by excluding the count=1 value. Hope this helps. Sample Data [image] Quick Sight Sample [image] Sample Calculation [image] Regards, …

@Karthik_Tharmarajan What calculation do you have for Count? There is no actual “count” directly from the dataset. It’s calculated by doing count(). It’s the pivot table that’s really doing the count based on property_id and IP address. That actual data is a bit different. Let me post an example si…

How to create a visual based on subtotal row from pivot table?

Q&A

Karthik_Tharmarajan June 9, 2023, 10:08pm 6

@jp207 , Try using LAC calc that I have in the screenshot below. Hope this helps.

Regards,
Karthik

Topic		Replies	Views
Pivot Table Subtotals not showing up Q&A quick-sight , level-aware , Business-Intelligence-Engineer	4	1163	February 16, 2024
Subtotal for a group of rows Q&A api , developer , quick-sight	1	90	May 7, 2024
Subtotal in Pivot Visual Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	48	March 21, 2025
Custom Subtotals in Total Section on Pivot Table Visual... Is this possible? Q&A formatting , feature-request , quick-sight , pivot-table , Business-Intelligence-Engineer	5	228	June 10, 2024
Subtotals of percentage column in Pivot table is not giving right results Q&A error , quick-sight , pivot-table , Business-Intelligence-Engineer	3	526	May 6, 2024

How to create a visual based on subtotal row from pivot table?

Related topics