Blank header row on flat table when rows and columns are swapped

Question & Answer
, ,
1

I’m using a flat table and I’ve swapped columns and rows so that dates are across the top. However there is now a blank row at the top of my table that I can’t get rid of. Do you have any suggestions?

image
image680×196 37.6 KB

2

Hello @Jordan_Hill , welcome the QuickSight community!

I think the easiest way would be to use a pivot table rather than a normal table visual.

The harder way would be to create calculations to make each date in your dataset a dimension field. But that would add a lot of development time and increase the size of your dataset so I would stick with trying a pivot table first.

1 Like
3

Thanks @duncan - the problem here is that I’ve intentionally set up my dashboard data to be in a format that doesn’t really work with the pivot table format, only the flat table format. Can you give a quick overview on how to turn a date into a dimension field?

4

Hey @Jordan_Hill

You would essentially do something like this:

ifelse( 
     {date} = 'dd-mm-yyyy', 'dd-mm-yyyy',
     etc....,
NULL)

The other option is to change your analysis settings to free form, and layer a blank text box over the top of your visual to cover the lines.

1 Like