Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to 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
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