-
1. Re: Pie Charts and Calculated fields
Mia Lee May 18, 2016 11:47 AM (in response to Kevin Price)Hi, Kevin
If you'd like to keep the detail of the weekly metrics, it'll dice it by week. You may try level of detail calculation - if you can post a sample workbook, I'll try demonstrating creating the calculated field.
-Mia-
-
2. Re: Pie Charts and Calculated fields
Jennifer PettiMay 19, 2016 4:13 PM (in response to Kevin Price)
Hi Kevin,
Mia's right- level of detail calculations will solve this problem. We can use LODs to calculate our number of records to the week level and then author our KPI calculation.
First, we'll need to create a new date part for just the week. Right click on your date dimension, and select create-->custom date. For this we'll select the date value of week numbers.
Now we can use this date part in our LOD expression.
{FIXED [Order Date (Week numbers)]: SUM([Number of Records])}
That gets us the number of records at the week level, and we can reference that calc in our KPI.
IF [Number of Records per Week] >= 45 THEN "High"
ELSEIF [Number of Records per Week] >= 25 THEN "Medium"
ELSE "Low"
END
If you want to see just one number for overall percentage of your groupings, you'll have to take the week field off of detail. Hopefully that's okay, since we're already using the week count as part of the calculation.
Cheers!
-
Percent of Weeks KPI.twbx 1.2 MB
-
-
3. Re: Pie Charts and Calculated fields
Kevin Price May 20, 2016 2:22 PM (in response to Jennifer Petti)Thanks for your input and level of detail! It looks like exactly what I need but I'm running Tableau version 8.2.7, which from my understanding does not support LOD expressions... Any suggestions from here? I'm doing some research as well in the mean time.