Hi Team,
Below is the data I have (in QuickSight). I am looking for a way to display only one row (for the ones highlighted in yellow). The “Average frequency” is a calculated field.
What is the best way to achieve this?
FYI… I will be hiding the User column
Hello @QuickSightRokie !
When you say you only want to show 1 row, do you mean that you want each user to only see data unique to them, or that you only want them to see data from 01/01/2023?
Or do you want the visual to be only one row across?
Hi @duncan
Thank you so much for your help on this!
Basically, if you take the first two rows, the Average frequency for master A is 18. So in this case, I am checking a way to see how I can display just one row.
As mentioned earlier, I will be hiding “user” column.
I am looking for an output like below
@QuickSightRokie I would suggest filtering by the “Master” and “Actiondate” fields so that only rows with those exact values you are looking for appear.
For this you would want to only make the filters apply to this visual and not include them on the sheet.
@QuickSightRokie - Did Duncan’s suggestion solve your issue? If so, would you please mark his response as Solution. If not, please let us know where you still need help.
Hi Kellie,
Encountered another error before we got to the step. I will update you once we try the recommendation.
Thank you!
Good morning @duncan,
So you basically want me to create a separate visual just using the actiondate and the master data. Correct?
In my current visual, I have multiple calculated fields which uses master and user data together to generate the needed output.
If I go with your recommendation, I will need to try creating calculated fields with just master and action date. Is that what you are recommending here?
Thank you!
Hi @QuickSightRokie,
If you need to show just one row per combination of Master and Date where the frequencies are the same, you can create a rank column, and then filter the visual for where the rank is 1. Does the below example work for you?
rankuser = rank([User ASC], [Master, Date, Frequency])
Apply a visual level filter where rankuser = 1.
If this works, please mark this as a solution. Thank you.
