Answers generated from Webex transcript and chat interactions
Q: Could you show how to add filter controls in a Quicksight Paginated report please ? First is this feasible ?
A: Within a paginated report, we haven’t exposed the option of a parameterized paginated report yet. That’s something which is in the works, but right now this is for interactive filtering.
Q: Can you also sort cross-visual on top of filtering cross-visuals?
A: NO, this sorting is still at the visual level. This is more of a filtering thing that we have applied here. This sort happens at the visual level."
Q: In case if I have regions on my dashboard and I want to rename aliases, is there a way to do so other than creating a calculated field?
A: Creating the calculated field is the work around we have today. Yeah, that’s that’s the way to go currently, there is no other way to change how a field appears. Except if you are dealing with tables and pivot tables, there of course you have the group by your value column options. So, let me show you what I mean.
So if you’re going into, let’s create a table and let’s say we’re having some group by values, and then you go in here into the properties, if you see the group by column names or value column names, you could change it from here. So if I change this to a custom industry, and apply that, you can see it changes here, right? So at a visual level, if it’s a table you could do this and then if it’s any other visual, you you have to change it at the field level by creating a calculated field.
Q: In terms of performance, is there any difference between using parameters and cross-sheet controls?
A: For the actual performance itself, there wouldn’t be any noticeable difference at all, just that the implicit filters are much more easier to set up. You don’t have to go through those extra motions of setting up the parameters, adding parameter controls and then hooking up the parameter to the filter itself. There is of course when you’re going through the parameter, there is an additional value being stored and that value being passed, but that doesn’t create any additional latency it’s it’s very, very negligible and you wouldn’t see any difference between the two if you try to prove measure the performance as such of the two kinds of filtering.
Q: The home page is not showing an option to create a sheet. Is it due to my login access?
A: Yeah, most likely yes, if you are within an analysis sheet, it should give you an option to create a sheet or if you’re already in an analysis where you have maxed out the number of sheets. Say you already have 20 sheets, then it will not let you add any more. So try creating a new analysis and try creating a sheet therein. If you’re still not able to, then I would highly recommend you reach out to your Quicksight admin within your org to see if there is anything going on with your user permissions.
Maybe if your user can’t downgrade and we don’t allow a downgrade from an author to a reader by default, but using apis, the admin can do that if they chose to. So just see if it’s any of those edge cases where they have done a user downgrade or any other sort of permission changes. But ideally, most likely you are maxed out. Open up a new analysis should let you get to a sheet.
Q: Is Quicksight only looking at same field names when applying the mapping across two datasets? Are the field names case-sensitive?
A: Case sensitive. That’s correct. That mapping happens based on the field names and yes, it’s case sensitive. It has to be the exact same in both data sets for to be able to latch on and say, hey, this has, this is the same field in both and I have to apply filter on both if that closed data set checkbox is enabled.