Search code examples
looker-studio

how create table / scorecard with last Date value in DataStudio?


I have this report, but I am not able to create scorecard or table with with latest date value. Before it was working in Scorecard with MAX(date) query, but I got info that "Scorecard not working this way anymore after last update", but seems that also in table not working. When you check the screenshots there is showing only type (Text) and not date type as expected. Any idea how to fix this please ?

FYI: now is showing in report last update from May 28, even there is also data May 29, but it sorted now according SUM(Confirmed) Values , unable to sort by date

Here is my report and some screenshots

https://datastudio.google.com/reporting/6e242aa8-9cda-47c4-8ef5-e52a7148d9bd

enter image description here

enter image description here


Solution

  • Adapted from an Earlier Answer, using an Editable Copy of the Google Data Studio Report above and a GIF to elaborate (feel free to have a look through and copy and paste the Table created below, in your report):

    1) Data Tab

    • Chart Type: Table
    • Dimension: date
    • Sort: date in Descending order
    • Rows per page: 1

    2) Style Tab

    • Show Header: Deselect
    • Row Numbers: Deselect
    • Show Pagination: Deselect
    • Table Labels Font Size: As required (e.g. 24px)
    • Cell Border Colour: Transparent

    3) Text Box & Grouping

    • Add a Text Box stating Max Date if required
    • Precision Movement: Use Shift + Movement keys to finely place the components exactly where required.
    • Groups: The Text Box and Table can be grouped so that it's treated as a single component, making it easier to move both components simultaneously