Is there anyway to recreate this in quicksight:
I have got the ‘This Week’ and ‘Last Week’ rows with all of the value fields required, I’m just not sure how you create the difference aspect to it so that sits on the row underneath, or any other suitable solution.
Any questions or issues and please just ask, many thanks.
Riley
Hello @riley.anderson, I believe you should be able to accomplish this. The easiest way for me to guide you on a solution for this question would be if you could create an analyis in QuickSight Arena with some demo data and then link that in a response. I would be able to then help you build a solution.
I believe you will need to utilize a pivot table to accomplish this format if you want it to be displayed as rows, but it should be possible.
Hi @DylanM,
Thank you for responding.
Here is an Arena demo: Difference Between 2 Rows
I have not replicated the full dataset and all of it’s complexities, I think whatever the solution is though I should be able to replicate in my actual dataset as the one provided is close enough and follows the same sort of structure.
Any questions or issues and please just ask, many thanks.
Riley
Hi @riley.anderson, most likely, the data orientation may have to change.
Also, here is some more guidance on how to compare between current and previous record and periodOverPeriodDifference function.
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
Hi @Xclipse,
Thank you for your response, I was aware of that but as I have a bunch of metrics in my real analyses this solution just wouldn’t work as I would need to create that calculated field for each metric and the visual just wouldn’t present as wanted.
I was hoping that @DylanM was able to demonstrate his solution after providing my Arena demo.
Any questions or issues and please just ask, many thanks.
Riley
