-
1. Re: Create Range of Days using Date field
Nicole Le Prohn Dec 19, 2017 12:31 PM (in response to Jesse Narang)Jesse, i'm not seeing a workbook attached...
-
2. Re: Create Range of Days using Date field
Barry OConnor Dec 19, 2017 12:42 PM (in response to Jesse Narang)1 of 1 people found this helpfulJesse,
One way to do this would be to create a calculated field like so:
This will create the calculated values you are looking for. To show those values with the monthly values, put them together in a dashboard:
-
3. Re: Create Range of Days using Date field
Jesse Narang Dec 19, 2017 1:32 PM (in response to Nicole Le Prohn)Hi Nicole,
That's weird because I still see the attached file but I have also attached it to this message. please let me know if you are still having issues viewing the file.
-
Sample Revenue Churn.twbx 11.2 KB
-
-
4. Re: Create Range of Days using Date field
Jesse Narang Dec 19, 2017 1:34 PM (in response to Barry OConnor)Hello Barry,
Thanks for your message. Is it possible for you to include the file also? Thanks!
-
5. Re: Create Range of Days using Date field
Barry OConnor Dec 19, 2017 1:45 PM (in response to Jesse Narang)Jesse,
Sure, here is the revised report. But what version of Tableau are you using? I am using 10.3, so if you are using an older version you may not be able to open it.
-
6. Re: Create Range of Days using Date field
Nicole Le Prohn Dec 19, 2017 2:04 PM (in response to Jesse Narang)it showed up after i refreshed. And i came up with the same basic formulas and recommendations as barry. hope it worked for you
-
7. Re: Create Range of Days using Date field
Jesse Narang Dec 19, 2017 2:35 PM (in response to Barry OConnor)Hello Barry,
Thanks for sending me the file!. It works great I do have one more question - Is it possible to make the table look like below:
So basically now the time intervals are - Revenue in first 7 days, Revenue in the first 15 days, Revenue in the first 21 days, Revenue in the first 28 days and then full month revenue.
Is that possible?
-
8. Re: Create Range of Days using Date field
Jesse Narang Dec 19, 2017 2:37 PM (in response to Nicole Le Prohn)Hello Nicole,
Thanks for your reply but I do have another question and if you or barry could solve it then that'd be great - Is it possible to make the table look like below:
So basically now the time intervals are - Revenue in first 7 days, Revenue in the first 15 days, Revenue in the first 21 days, Revenue in the first 28 days and then full month revenue.
Is that possible?
-
9. Re: Create Range of Days using Date field
Nicole Le Prohn Dec 19, 2017 3:54 PM (in response to Jesse Narang)1 of 1 people found this helpfulsure. change the formula to look like this so your headers look better:
IF DAY([Date]) < 8 THEN
'Revenue between ' + str(DATENAME('month',[Date])) + ' 1-7'
ELSEIF DAY([Date]) < 15 THEN
'Revenue between ' + str(DATENAME('month',[Date])) + ' 1-14'
ELSEIF DAY([Date]) < 22 THEN
'Revenue between ' + str(DATENAME('month',[Date])) + ' 1-21'
ELSEIF DAY([Date]) < 28 THEN
'Revenue between ' + str(DATENAME('month',[Date])) + ' 1-28'
ELSE
'Total Revenue for ' + str(DATENAME('month',[Date]))
END
and then do the revenue as a running sum across, restarting every month.
workbook attached...although in 10.4 so you might not be able to open it. Let me know if you need more help.
Nicole