Jump to content
We've recently updated our Privacy Statement, available here. ×

mark column which has changed in a new row of the table


Recommended Posts

Hello all,

I am working with a table where there are the following columns:ID, timestamp and differents features (A,B and C). Each row is an event of any ID (more than one event of each ID is expected). I am tryng to get marked with a different color the column which has changed for each event (row)with regards the last row of the same ID.

I have attached a image representing the table that I want to create.

Please could anyone help me on tihs

Link to comment
Share on other sites

Marking throughout the visualization can only be of same color. You can setup rules in coloraxis to show the changed value in comparison to previous row with expression like:

[Axis.Color]>First([Axis.Color]) OVER(Previous([RID]))

 

Where RID calculated column is RowID()

 

Current, showing records in red color where the Rank is higher than previous rank

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...