Hello ,
I have three fields: Pattern / Month / Value
I would like to display thru Sankey Diagram a month over month movement in the Pattern. Therefore, the Sankey would have Two Dimensions: Pattern_-1 month and Pattern_Current Month
- I can show Dimensions Pattern and Date as you see below, but I would prefer to only display Pattern prior month and Pattern current month.
- I tried a set analysis for current month but did not work: Aggr(Only({<Date={'04/01/2017'}>} Pattern ), Pattern)
Any guidance will be appreciated.