-
1. Re: Remove "noise"data from line graph
Joe OppeltNov 16, 2017 2:13 PM (in response to Nancy V)
Do you know the launch date?
If you have a launch date per product, you could make a calc like this:
IF [transaction date] >= [launch date] then [Value] END
And then you would use SUM([this new calc]) throughout the application instead of doing SUM([Value]). Because there is no ELSE in that calc, you'll get NULL for all values before the launch date.
-
2. Re: Remove "noise"data from line graph
Nancy V Nov 16, 2017 2:33 PM (in response to Joe Oppelt)I only want the data to be excluded for 1 product...the rest do not need this exclusion.
-
3. Re: Remove "noise"data from line graph
Joe OppeltNov 16, 2017 2:51 PM (in response to Nancy V)
That's OK.
IF [Product] = "my special product" then
IF [transaction date] >= [launch date] then [Value] END
ELSE
[Value]
END
-
4. Re: Remove "noise"data from line graph
Nancy V Nov 16, 2017 3:24 PM (in response to Joe Oppelt)It still doesn't work. I have attached a sample workbook to the original post.
In this workbook, i want design data to be only visible from week 38. everything before that needs to be blank (which means i do not want to see a line in the graph at all)
-
5. Re: Remove "noise"data from line graph
Shinichiro MurakamiNov 16, 2017 6:59 PM (in response to Nancy V)
HI Nancy
I hope this helps.
First of all, your "Week" is difficult to sort on the formula because string "Week 11" comes beyond "Week 2".
I converted week to below two digit format.
Then Assuming Design 2 is BETA until WW38,
Thanks,
Shin
-
test workbook_SM_10.1.twbx 15.3 KB
-
-
6. Re: Remove "noise"data from line graph
Nancy V Nov 16, 2017 10:47 PM (in response to Shinichiro Murakami)Hi Shin,
This is great. I need to perform the same action on another data set BUT the week format in that data set is : "YYQ#WW". Some example weeks are: "17Q101" , "17Q411" etc. How could i convert this field?
-
7. Re: Remove "noise"data from line graph
Shinichiro MurakamiNov 16, 2017 10:59 PM (in response to Nancy V)
Hi Nancy
Information is not enough.
Give me the first and last week ID of each quarter.
I am asking
17Q101~17Q113, 17Q201~17Q213 ~~~~ 17Q413
or
17Q101~17Q113, 17Q214~17Q226 ~~~~ 17Q453
Shin
-
8. Re: Remove "noise"data from line graph
Nancy V Nov 16, 2017 11:33 PM (in response to Shinichiro Murakami)17Q101~17Q113, 17Q201~17Q213 ~~~~ 17Q413
so the first and last of each quarter would be:
17Q101
17Q113
17Q201
17Q213
17Q301
17Q313
14Q401
14Q413
18Q101
etc
-
9. Re: Remove "noise"data from line graph
Shinichiro MurakamiNov 17, 2017 5:27 AM (in response to Nancy V)
HI Nancy,
As long as the "week" part shows two digits like 01,02.... you can directly use this field in the formula.
I don't know when is the WW38, but assuming 17Q312, the formula should be like below.
//Design 2 Mod//
if [YYQ#WW] > "17Q312" then [Design 2] end
With given format, week is automatically judged "<",">" correctly in the formula..
(One digit , two digits combined format has a problem)
Regards,
Shin
-
10. Re: Remove "noise"data from line graph
Nancy V Nov 17, 2017 1:00 PM (in response to Shinichiro Murakami)Hi Shin,
I tried this but i get the following error: "Cannot mix aggregrate and non-aggregrate comparisons or results in 'if' expression"
-
11. Re: Remove "noise"data from line graph
Shinichiro MurakamiNov 17, 2017 1:39 PM (in response to Nancy V)
Please attach failure workbook.
Shin
-
12. Re: Remove "noise"data from line graph
Shinichiro MurakamiNov 17, 2017 2:44 PM (in response to Shinichiro Murakami)
Try below if [Design 2} is already aggregated, but anyway, need to see the data.
//Design 2 Mod//
if attr([YYQ#WW] )> "17Q312" then [Design 2] end
Thanks,
Shin
-
13. Re: Remove "noise"data from line graph
Nancy V Nov 17, 2017 3:33 PM (in response to Shinichiro Murakami)1 of 1 people found this helpfulthis worked like magic!! thank you