Graph and chart

Column 1 Column 2 Column 3 Column 4 E
Profit Sales Rate Total
2024 June YTD 149943 37373 25 60000
2024 Estimate FY 291786 (+29%) 72947 (+47%) 25 (+2%) 75797 (47%)
2023 FY 225433 49595 22 51956

can we build this type of table in quicksight. how to show 29%,47% etc in the table?

Hey @bhumika18s ,

I think it’s possible. Column2/3/4/E needs to use an ifelse and concat. For column 2 something like:
ifelse(column1 =x, tosting(sales), concat(tostring(sales), ’ (+', tostring(percentcalculation), ‘%)’)
could work.
If you could provide some test data or a test-analysis in Arena, that would be helpful.

BR
Robert

attached is the sample data. we have to build the above table. So, we only have Data till June 2024- we will be estimating data for another six months for 2024. For FY 2023 we have complete data.

@bhumika18s
How do you estimate the last six months? for a table there is noch forecast option.
Do you have a calculation already, if so, maybe you could implement it in QuickSight. I don’t know how to make one, on dataset level there is an option to make a predictive field but i haven’t used it and don’t know how it works.
We could try to help you but I need more information, maybe someone else has an idea.

And if its just calculation you need: sum(last year)/sum(this year)*100.

BR
Robert

I can get the estimated data for 2024 after multiplying no of months with the average we have for existing months.

My que is when i am using concat to display the percentage (as someone mentioned above)
ifelse(column1 =x, tosting(sales), concat(tostring(sales), ’ (+', tostring(percentcalculation), ‘%)’)
it is giving me long number e.g :- 45.344450

and i am not able to format it

You could usee Round - Amazon QuickSight for formatting. Like tostring(round(calculation, scale) etc.

Hi @bhumika18s ,

I’m marking Robert’s (@robert.eibers ) first response as solution to your post.
Please do let us know if you are still facing any challenge with this.

Regards,
Pr QuickSight SA

this is not working…the moment i apply tostring, the formatting till 2 decimal places vanishes

isn’t it another way- either KPI or insight ?