| 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 Quick Sight. 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 Quick Sight 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 Quick Sight 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 ?
