KPI basics <Scorecards>

Bear with me, please. Relativly new to Spotfire. What do I need to make? A few scorecards. 

I have a dataset that has a column [Number] it is a uniqueID for a error ticket. Another column is [sys_created_on] it is a date stamp (MM/DD/YYYY HH:MM:SS)

In other tools creating a quick snapshot of summaries was easy. Most likely it is here as well. Just damned if I can figure it out.

I'm looking for three tiles: YTD, MTD, WTD of all tickets created. Then in the comparison portion a count (or ideally a percentage difference) comparison of the previous.

ie: YTD (current year, 2019) compared to previous year (2018); MTD (current month October 2019) compared to previous month (September 2019), WTD (3rd week October) compared to week 2 of October

How might I go about this? 

 

 

Login