Forum Discussion
Visualize state changes
Hello. I'd like to visualize changes in a state (as in status). I have items that can move between states. To Do > In progress > Done for example. and i'd like to visualize this flow. The da...
Hi Anonymous ,
I check custom visual but haven't found any custom visual suitable for your requirement. Maybe you can try to use python visual or r visual to manually draw these graph.
Regards,
Xiaoxin Sheng
Hi Anonymous ,
You can use following calculate column formula to achieve your requirement:
Status =
VAR _fDate =
CALCULATE (
MIN ( Table2[Date] ),
FILTER ( ALL ( Table2 ), [ID] = EARLIER ( Table2[ID] ) )
)
VAR _diff =
DATEDIFF ( _fDate, Table2[Date], DAY )
RETURN
IF ( _diff < 3, "To do", IF ( _diff >= 3 && _diff < 5, "In progress", "Done" ) )
Status Changed =
VAR _preview =
CALCULATE (
MAX ( Table2[Date] ),
FILTER (
ALL ( Table2 ),
[ID] = EARLIER ( Table2[ID] )
&& [Date] < EARLIER ( Table2[Date] )
)
)
RETURN
IF (
_preview <> BLANK (),
[Status]
<> LOOKUPVALUE ( Table2[Status], Table2[ID], [ID], Table2[Date], _preview )
)
Status Flow =
VAR _preview =
CALCULATE (
MAX ( Table2[Date] ),
FILTER (
ALL ( Table2 ),
[ID] = EARLIER ( Table2[ID] )
&& [Date] < EARLIER ( Table2[Date] )
)
)
RETURN
IF (
_preview <> BLANK (),
LOOKUPVALUE ( Table2[Status], Table2[ID], [ID], Table2[Date], _preview ) & " to " & [Status],
[Status] & " to " & [Status]
)
Regards,
Xiaoxin Sheng
I Already have the data as shown. I would like to create a viz something like i showed
Hi Anonymous ,
I check custom visual but haven't found any custom visual suitable for your requirement. Maybe you can try to use python visual or r visual to manually draw these graph.
Regards,
Xiaoxin Sheng