cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bsas Member
Member

How to build sankey chart using monthly snapshoots

 Hi all,

 

I'm trying to build sankey based on monthly snapshoots in selected period, where start date is min snapshoot date in period and end date is max snapshoot date in period. We should ignore all other snapshoots within the period. 

 

example of my table

 

IDdatestage
1111/31/20182
1112/28/2018(ignore it)
1113/31/20183
2222/28/20182
2223/31/2018(ignore it)
2224/30/2018(ignore it)
2225/31/20184


same table if we change period 

 

IDdatestage
1111/31/20182
1112/28/20183 (ignore it)
1113/31/20183
2222/28/20182
2223/31/20183

 

Will appreciate any help with this.

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to build sankey chart using monthly snapshoots

@bsas,

 

You may try adding a measure and drag it to Visual level filters.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bsas Member
Member

Re: How to build sankey chart using monthly snapshoots

Thanks @v-chuncz-msft,

 

In my case I need to create calculate column which will ged value from min date in selected period (same for max) and set it for all record in appropriate ID (e.g. in case I have 4 raws with same ID and 4 dates column should get value from date raw which <= min date in period. Same approach for Max. I need this min and max as calculated column because will use it as source and destination in sankey chart.

 

IDdatestageminalternative minmaxalternative max period 1/20/2018 - 5/2/2018
11111/31/201822244  
11112/28/201832 4   
11113/31/201832 4   
11114/30/201842244  
         
         
IDdatestageminalternative minmaxalternative max period 2/10/2018 - 4/24/2018
11112/28/201832233  
11113/31/201832233