Say I have this visual and I want percent differences between the light blue and dark blue bars. The two bars are categories of time, but they are strange categories like (Jan-Feb of 2019 compared to Nov 2021-Aug 2023). I don’t care if the differences are in a table or an insight or a kpi. The y a…

@nw2this just to be clear, do you want to display the %diff between the age group population between 2 different timeframes? I don’t think this is possible, this is the little outside general definition of the group bar chart. The current QS group bar chart can only let you display the column that…

Hi @nw2this , maybe you can tried something with difference depending on you data. Difference - Amazon QuickSight The difference function calculates the difference between a measure based on one set of partitions and sorts, and a measure based on another. BR …

I want the percent difference in the numbers the bars represent. It doesn’t have to be on a bar chart.

@nw2this can you share sample data output? At this point, I am confused about what you are looking for. if you want to display, % change, you can do the calculated field, calculate % diff there with the formula, and use that in the bar chart.

@ArunSanthosh @neelay @ErikG This is what I am trying to accomplish but I don’t have two separate fields (current sales and prior sales), I have one sales field that is aggregated by categorical fields (a current/prior category and a product category). So, I think I need to combine the difference …

Hi @nw2this , Glad to know that you are closer to resolving your issue. In the sample I shared, I’m working on top of a single sales field as well. The current and prior sales columns are calculations on top of this measure column.. Regards, Arun Santhosh Principal Quick Sight SA

Hello @nw2this ! Was @ArunSanthosh 's post helpful in resolving this problem and if so could you mark their post as a solution? It has been some time since we have heard from you, but would still like to help you find a solution. If we do not hear from you in 3 days this post will be archived.

Not sure if this is a period over period question?

Q&A

ArunSanthosh November 21, 2023, 7:38pm 6

Hi @nw2this,

Percent difference can be calculated and displayed as a tool tip in the bar chart or as standard column in a table. See this dashboard for more details - Percent Difference Between Different Time Periods

Regards,
Arun Santhosh
Principal Quick Sight SA

Topic		Replies	Views
Calculating Percentage Difference Q&A formulas , analysis , date , quick-sight , calculations , Business-Intelligence-Engineer	8	2219	February 3, 2025
Adding percentage difference to a bar chart Q&A feature-request , quick-sight , tooltip , visuals , Business-Intelligence-Engineer	4	347	March 20, 2024
Comparison of row total percent between two charts with date Q&A formulas , analysis , quick-sight , visuals , calculations , Business-Intelligence-Engineer	2	380	November 24, 2023
Insight visual computation help Q&A developer , error , feature-request , quick-sight	4	60	August 23, 2024
Difference between two fields and aggregation Q&A quick-sight	9	1293	June 26, 2023

Not sure if this is a period over period question?

Related topics