Hi all
I would like to create a scorecard chart that shows the following.
Total (based on current count of records in latest data partition in BQuery data table) and below, using the the comparision metric, show the percentage change from the count of records in the previous data partition in the table.
Currently no value ever appears when trying the options
Comparison type - Full stop
Comparison date range - previous period.
The BQ table is divided into multiple partitions as we ingest a weekly snapshot of data. Therefore i simply wish to show the percentage change in the number of records between the current and previous weeks partition. All examples i have followed on youtube etc show it magically working but no comparison data ever appears in my case.
Any ideas ?
LinkedIn
Twitter
