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?