Hi,
I'm trying to figure how to complete a data set. And by completing a data set, I intend to stress on the areas of the dataset that are incomplete.
For example,
Let's say we're trying to show the status of a text sent through messenger.
1. Sender typing
2. Message sent
3. Text received
4. Text read
Now if I have the data showing only the current status of the text and in the visualization, I mean to show a progressing status. How do I do that?
Sample data is as below.
USER ID
STATUSUSER1Message sentUSER2Text received
Sample viz shown below.
Any help would be highly appreciated.
Vignesh,
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.
Kaz.
