Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I trying to do a Sankey chart for my payment step.
The payment step is as follow Request initialization, if initialization OK then request validation.
I am able to one level sankey chart
but when I do the multilevel, I am getting a return flow
==========================
SANKEY table = UNION(
SUMMARIZE(FILTER(pmt, pmt[Method Of Payment] = "AMOP" && pmt[Transaction Type] = "Authorization" && pmt[Step] = "Initialization"), pmt[Status], pmt[Step], "count", COUNT(pmt[PRI])),
SUMMARIZE(FILTER(pmt, pmt[Method Of Payment] = "AMOP" && pmt[Transaction Type] = "Authorization" && pmt[Step] = "Validation"), pmt[Status], "Status2", "OK", "count", COUNT(pmt[PRI]))
)
==========================
I renamed Validation column to "Status2", "OK"
What I want is the Initiliasion OK column goes to another status response for the validation status
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |