Isolate most recent value in an analysis table

Support, Troubleshooting, & Help
1

Hi,

I’m looking to create some sort of expression that would isolate only the most recent value for the column called Trailer #. I tried a simple MAXIMUM(, but I got an error saying “Incomplete or invalid chart configuration.”

image
image1916×858 81.7 KB

2

Hey @codygarcia

  1. If you move all of your columns except trailer # to Groupings, you will be able to perform “Operations” on your “Groupings”.
  2. You will be able to do Maximum but there is no operation for “Most Recent Value”. Good feature request idea, although this starts to get into window functions which Tulip is very far away from offering.
  3. An alternative approach would be to utilize an automation to flag which rows are the “most recent” and then update all the others. This gets messy. But that is how you will need to be thinking to resolve this issue. Or use a custom widget connected to the Tables API.

Happy Tulip-ing!

3

Hi Daniel,

So I grouped all columns as you suggested, then set the Load (previously called Trailer) # to Maximum. My end goal is to have the analysis only show the items that contain max value, in this case 20. Could you please review what I’ve done below and let me know what I need to fix/change?

image
image1915×809 93.8 KB

Thanks!

4

Hey Cody,

As I alluded to– this is not possible in Tulip currently. You will need to explore more creative workarounds which I don’t think I could explain without a lot more context.

Daniel

5

Hi Cody,

If you are just trying to isolate the most recent value for the column, you can try:

  1. Adding the “Date Created” or “Date Updated” table field to the grouping.
  2. Using the limit and sorting feature to limit to 1 record and sort by “Date Updated/Created - Ascending”

You can see that I am able to isolate the most recent batch in this example.

This will work perfectly if the “Trailer” field is the last field to be updated in the table - if not, it might be worth adding a field in the table like “Trailer Update/Selection Time” that is populated with the current time/date at the same time as the “Trailer” field is updated, allowing you to track which record was actually updated most recently in regards to that field.

image
image1914×748 75.2 KB

image
image1914×601 56.5 KB

Does this make sense? If I have understood your requirement correctly, this should work to give you the table record that most recently had it’s “Trailer” field updated.

Kind regards,

Suraj Patel
Bow&Stern IT Professional Services

6

Hi Suraj,

If I was to embed an interactive table into an app step, could a user be able to filter values within the player?

Thanks,

Cody Garcia