Calculating difference between dates in the same visualization

[iwnyk]

This is the way the data is pulled from a particular system.

First Name	Last Name	Date of Appointment	Status	Status Date
Jane	Smith	01/02/2000	XYZ	05/02/2000
Jane	Smith	02/02/2000	XYZ	05/02/2000
Jane	Smith	04/02/2000	XYZ	05/02/2000

Is there a way to find the total number of times Jane Smith has come in for an appointment?

Is there a way to calculate the number of days it took for Jane Smith to reach status XYZ from her last appointment (viz the last row for a given person),

ideally both of these questions would be answered in the same visualization?

Any help would be great.

[TomMartens · Accepted solution]

Hey @iwnyk ,

I'm not sure what data visualization you imagine. Can you create a scribble?

Next to that, you should consider creating a dimension table that contains the "customer" and create a column in your existing table that contains the "customer" Jane Smith in a single column. It's not possible to create a data visualization where the axis label "Jane Smith" is derived from two columns, except for hierarchical labels.

Regards,

Tom