Hello -
I am trying to figure out if it is possible in an Insight to do math against two arbitrary rows in a dataset. Say for instance I have a “projects” dataset and I want to do a time diff of project create time(date) against two projects selectable by a user. We would need a dropdown to pick two different ids from a list to compare against. We can’t use a filter with two selections in, because the math would be backwards depending on order (if it was even possible to do it).
I could write a SQL query to do this, but it requires two variables to be passed in.
Thanks
Best answer by Moises Morales
View original