Tableau - How sum values with 12 last months The Next CEO of Stack OverflowHow to sum the average over a monthHow to Calculate YTD (Jan to prev month) in a single column in tableauTABLEAU Calculating a Running DISTINCT COUNT on usernames for last 3 monthsTableau Crosstab Row Percentage of WholeGoogle Big Query and TableauTableau - Combining two column Values into a dropdown listFilter date from last 3 months to next 3 monthsPick group totals, grand totals and normal summarization in Tableautableau count non zero values in a rowTableau Sum of Month Sales with Las Account Customer Item Sale of the month
What is meant by a M next to a roman numeral?
WOW air has ceased operation, can I get my tickets refunded?
Why here is plural "We went to the movies last night."
When did Lisp start using symbols for arithmetic?
Whats the best way to handle refactoring a big file?
Should I tutor a student who I know has cheated on their homework?
How should I support this large drywall patch?
How to be diplomatic in refusing to write code that breaches the privacy of our users
Why didn't Khan get resurrected in the Genesis Explosion?
Visit to the USA with ESTA approved before trip to Iran
Why does standard notation not preserve intervals (visually)
How to safely derail a train during transit?
What's the point of interval inversion?
What can we do to stop prior company from asking us questions?
How to Reset Passwords on Multiple Websites Easily?
Grabbing quick drinks
Are there languages with no euphemisms?
How to write papers efficiently when English isn't my first language?
Why do remote companies require working in the US?
How to make a software documentation "officially" citable?
Is there a good way to store credentials outside of a password manager?
How do I construct this japanese bowl?
How do I solve this limit?
How do spells that require an ability check vs. the caster's spell save DC work?
Tableau - How sum values with 12 last months
The Next CEO of Stack OverflowHow to sum the average over a monthHow to Calculate YTD (Jan to prev month) in a single column in tableauTABLEAU Calculating a Running DISTINCT COUNT on usernames for last 3 monthsTableau Crosstab Row Percentage of WholeGoogle Big Query and TableauTableau - Combining two column Values into a dropdown listFilter date from last 3 months to next 3 monthsPick group totals, grand totals and normal summarization in Tableautableau count non zero values in a rowTableau Sum of Month Sales with Las Account Customer Item Sale of the month
in Tableau I have a table with this form :
rows: Score.
columns:MY(month), sum(good), sum(bad).
This is the information when I use: month 201811
201611 201612 ... 201801 ... 201811 TOTAL
Score Good Bad Good Bad Good Bad ... Good Bad
1 3 0 7 3 6 3 2 1
2 5 1 1 1 1 1 4 4
3 10 3 2 1 0 3 3 3
I want to use a filter with 'Month' column ,when I filter month=201811, show since 201611 to 201711 (last 12 months) in Total column(Totals in Bad and Good columns) by Score.
Filter: 201811
Formula: sum(Good) and sum(Bad) since '201611' to '201711'
I trying "IF DATEDIFF('month', [Good], today()) <=12" but doesn't work.
Thanks for your help.
tableau
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
add a comment |
in Tableau I have a table with this form :
rows: Score.
columns:MY(month), sum(good), sum(bad).
This is the information when I use: month 201811
201611 201612 ... 201801 ... 201811 TOTAL
Score Good Bad Good Bad Good Bad ... Good Bad
1 3 0 7 3 6 3 2 1
2 5 1 1 1 1 1 4 4
3 10 3 2 1 0 3 3 3
I want to use a filter with 'Month' column ,when I filter month=201811, show since 201611 to 201711 (last 12 months) in Total column(Totals in Bad and Good columns) by Score.
Filter: 201811
Formula: sum(Good) and sum(Bad) since '201611' to '201711'
I trying "IF DATEDIFF('month', [Good], today()) <=12" but doesn't work.
Thanks for your help.
tableau
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
add a comment |
in Tableau I have a table with this form :
rows: Score.
columns:MY(month), sum(good), sum(bad).
This is the information when I use: month 201811
201611 201612 ... 201801 ... 201811 TOTAL
Score Good Bad Good Bad Good Bad ... Good Bad
1 3 0 7 3 6 3 2 1
2 5 1 1 1 1 1 4 4
3 10 3 2 1 0 3 3 3
I want to use a filter with 'Month' column ,when I filter month=201811, show since 201611 to 201711 (last 12 months) in Total column(Totals in Bad and Good columns) by Score.
Filter: 201811
Formula: sum(Good) and sum(Bad) since '201611' to '201711'
I trying "IF DATEDIFF('month', [Good], today()) <=12" but doesn't work.
Thanks for your help.
tableau
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
in Tableau I have a table with this form :
rows: Score.
columns:MY(month), sum(good), sum(bad).
This is the information when I use: month 201811
201611 201612 ... 201801 ... 201811 TOTAL
Score Good Bad Good Bad Good Bad ... Good Bad
1 3 0 7 3 6 3 2 1
2 5 1 1 1 1 1 4 4
3 10 3 2 1 0 3 3 3
I want to use a filter with 'Month' column ,when I filter month=201811, show since 201611 to 201711 (last 12 months) in Total column(Totals in Bad and Good columns) by Score.
Filter: 201811
Formula: sum(Good) and sum(Bad) since '201611' to '201711'
I trying "IF DATEDIFF('month', [Good], today()) <=12" but doesn't work.
Thanks for your help.
tableau
tableau
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
edited Mar 21 at 16:45
Victoria Ubaldo
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
asked Mar 21 at 16:30
Victoria UbaldoVictoria Ubaldo
509
509
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Try this:
If DATEDIFF("month",TODAY(),[Your Date Field],"Sunday") <= -12
then [Your Date Field] else null end
Then use that as your date column. The "Sunday" is supposed to be whatever you consider the starting day of the week. I wasn't sure what your date field is named so I named it "[Your Date Field]"
answered Mar 21 at 19:17
waverywavery
1365
Thanks for your help.
– Victoria Ubaldo
Mar 21 at 23:02
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55285125%2ftableau-how-sum-values-with-12-last-months%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try this:
If DATEDIFF("month",TODAY(),[Your Date Field],"Sunday") <= -12
then [Your Date Field] else null end
Then use that as your date column. The "Sunday" is supposed to be whatever you consider the starting day of the week. I wasn't sure what your date field is named so I named it "[Your Date Field]"
answered Mar 21 at 19:17
waverywavery
1365
Thanks for your help.
– Victoria Ubaldo
Mar 21 at 23:02
add a comment |
Try this:
If DATEDIFF("month",TODAY(),[Your Date Field],"Sunday") <= -12
then [Your Date Field] else null end
Then use that as your date column. The "Sunday" is supposed to be whatever you consider the starting day of the week. I wasn't sure what your date field is named so I named it "[Your Date Field]"
answered Mar 21 at 19:17
waverywavery
1365
Thanks for your help.
– Victoria Ubaldo
Mar 21 at 23:02
add a comment |
Try this:
If DATEDIFF("month",TODAY(),[Your Date Field],"Sunday") <= -12
then [Your Date Field] else null end
Then use that as your date column. The "Sunday" is supposed to be whatever you consider the starting day of the week. I wasn't sure what your date field is named so I named it "[Your Date Field]"
answered Mar 21 at 19:17
waverywavery
1365
Try this:
If DATEDIFF("month",TODAY(),[Your Date Field],"Sunday") <= -12
then [Your Date Field] else null end
Then use that as your date column. The "Sunday" is supposed to be whatever you consider the starting day of the week. I wasn't sure what your date field is named so I named it "[Your Date Field]"
answered Mar 21 at 19:17
waverywavery
1365
answered Mar 21 at 19:17
waverywavery
1365
answered Mar 21 at 19:17
waverywavery
1365
answered Mar 21 at 19:17
waverywavery
1365
1365
Thanks for your help.
– Victoria Ubaldo
Mar 21 at 23:02
add a comment |
Thanks for your help.
– Victoria Ubaldo
Mar 21 at 23:02
Thanks for your help.
– Victoria Ubaldo
Mar 21 at 23:02
Thanks for your help.
– Victoria Ubaldo
Mar 21 at 23:02
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55285125%2ftableau-how-sum-values-with-12-last-months%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
