Renaming Table Columns for SQL Results

I have a simple report that handles aggregating inbound referrer URLs and the number of sign-ups they result in.

The SQL query I use results in two columns: `[url, sign_ups]`.

When I add this to a Mode report, the columns show up as-is in the report display:

 

This is fine for my own internal use, but for displaying to stakeholders, I would like to be able "beautify" the table somewhat by changing the names of the columns to "URL" and "Sign Ups".

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi David , May I ask what database this report is using?  

    Reply Like
  • Hey Donna , this is using Amazon Redshift. So even if I was to try using `SELECT sign_ups as "Sign Ups"…`, that will still result in `sign_ups`.

    Reply Like
  • Hi David Antaramian - apologies for the delayed response. This is a known limitation of Redshift - column aliases are always returned in lowercase, which makes it hard to style column headers in tables.

    That said, you can easily compensate for this limitation in Mode. In the report editor, click "Edit HTML" and add the following code to the top of the HTML for your report:

    <style>
    .axel-table-header-label {
      text-transform: capitalize;
    }
    </style>

    This will capitalize the first letter of all of the words in each column header. More information about using the text-transform CSS property here:

    https://love2dev.com/blog/css-text-transform/

    Hope that helps - please do reach out to our success team via in-product chat or success@modeanalytics.com if we can be of further assistance. Thanks!

    Reply Like
  • Hey Jonathan Krangel - Thanks for the response!

    Reply Like
reply to topic
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 4Replies
  • 350Views
  • 4 Following

Create A New Discussion

Share your thoughts