Loop on column to generate pdf with number of sheets equal to number of values

Question & Answer
, , ,
1

Hi Experts,
Need help in developing a pdf report where we need to cycle through a column for the same visuals.
Example:
p1
p2
p3
For all three values i want to repeat the visuals in paginated pdf report.
Is it possible to achieve this?

2

Hello @syed_imran, my initial thought on this request is that it is not available in QuickSight, but I am also not sure I totally understand what you are asking. I have a few questions:

  1. Are you building your dashboards/analyses through QuickSight APIs in code or are you making them in the QuickSight consoles?
  2. Are you wanting to pull specific data from a single visual and add that data to a paginated report?
  3. What do you expect the paginated report to display when this is completed?

With some more information I can try to guide you towards a solution. Thank you!

3

Thanks @DylanM
I am migrating reports from Qliksense to AWS Quicksight.
We have a report in Qliksense/Qlik Nprinting where we generate a ppt.
PPT includes three visuals like pie charts for every project in my organization.
For example i have 20 projects , Qlik nprinting cycles through 20 projects and generates 20 slides ppt each representing the pie for respective project.
Can we do this in Quicksight or any other workaround?

1 Like
4

Hello @syed_imran, okay, you want to generate a Powerpoint based on visuals from multiple dashboards, is that correct? And you already have these dashboards created in QuickSight?

There is not currently a way to accomplish this directly through QuickSight. You could utilize the paginated reporting feature and build it with the visuals and datasets that you would want to share in a PDF. That would likely be the best work-around to achieve something similar to what you were doing in Qlik. I’ll link some documentation below. Let me know if this helps!

5

Thanks @DylanM
But do i need to create those visuals those many times ?

1 Like
6

Hello @syed_imran, if you build the paginated report on a sheet in the analysis version of one of your dashboards, you could duplicate any of the necessary visuals from another sheet and build the remaining visuals you would want.

I suppose if you are savvy with code, you could build this through the boto3 SDK, but that would require some level of knowledge with Python, JavaScript, etc. If you aren’t building anything in QuickSight through the APIs, that process would be significantly more complicated than rebuilding the visuals again. In QuickSight, it is not uncommon to have to rebuild things multiple times if you are working within the QuickSight console.

7

Can you please direct me to the api’s i can use to create a ppt document looping on a column values.?
I can try doing lambda function.

8

Hello @syed_imran, I am going to be honest, I am still not certain you will be able to accomplish exactly what you are wanting to do, but I can link the documentation.

Here are all of the API functions:
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight.html

describe_anaysis_definition will give you information specific to your visuals if you wanted to get IDs for single visuals to utilize elsewhere.
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/describe_analysis_definition.html

I’ll include the response syntax documentation from AWS as well:

You may have some luck utilizing these functions to get your desired output. I’ll mark this as the solution, but let me know if you have any follow-up questions.