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 ?