Look at creating a table/query that gets you the 4 different statuses, and then do an outerjoin based on the status column with your user data.
Thanks for the reply!
Give this a try and see if it works.
If your various statuses are sequential, as you have described, then you could create a series of calculated fields, one for each status, that look something like this:
And then, create a viz where you place the User ID on the Rows shelf, and place Measure Names on the columns shelf, and Measure Values on the Color tile, on the Marks shelf, and select Shapes as your Marks type, so that you get something that looks like this:
And this is based on a data source that looks like this:
Does that address your objective? Please let us know.
YuvarajExample.twbx 16.3 KB
Yeah, it sure does. I had the something similar in mind but was worried about the performance of the dashboard once I deal with larger dataset.
I really appreciate putting your thought and time into this. Thanks much!