This is very odd - I built a set analysis chart and it was working great. Then after a manual reload it stopped working. You can see below with the highlighted examples, that I can get "40187" to work so long I don't do any "math" against it -
Works and evaluates --
=Sum ({$<[DFA_Search.DayNumber]={$(=Only(DFA_Search.DayNumber))}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
Doesn't work (but I am pretty sure it was at some point)
=Sum ({$<[DFA_Search.DayNumber]={$(=only(DFA_Search.DayNumber)-1)}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
DFA_Search.DayNumber is defined as --
NUM
(ReportDate) AS 'DayNumber',
Keyword | =Sum ({$<[DFA_Search.DayNumber]={40187}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0)) | =Sum ({$<[DFA_Search.DayNumber]={40186}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0)) |
| 391 | 0 |
foo | 5 | 0 |
foo | 1 | 0 |
foo | 2 | 0 |
foo | 1 | 0 |
foo | 2 | 0 |
foo | 2 | 0 |
verses
Keyword | =Sum ({$<[DFA_Search.DayNumber]={40186}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0)) | =Sum ({$<[DFA_Search.DayNumber]={40185}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0)) |
| 466 | 0 |
foo | 1 | 0 |
foo | 2 | 0 |
foo | 2 | 0 |
foo | 1 | 0 |
foo | 1 | 0 |
foo | 4 | 0 |
Does anyone have any ideas on if my syntax is wrong or if I am missing something.
Thanks,
Chris
