Solved: Conditional display column name for different view... - Page 2

Paco_Delacroix · 02-19-2024 11:13 AM

Hi,
I have two tables:
Items & SubItems
There are 2 slices for SubItems Table: Filtered by "Payed" and "To Be Payed"
I ve created 2 views for each slice.
I ve created a conditional display name in the "Payed-TobePayed" column in the SubItems table as follows:
IFS(CONTEXT("View")="Payed", "Payed", CONTEXT("View")="ToBePayed", "To Be Payed")
if i execute each view independently it works fine, but when it is included into a Dashboard the conditional display name does not work.
Is there a workaround or a solution for this as the context("View") is equal to the "Dashboard View"?
thanks

aneville

I see what you are saying, I don't think you can do it using your Context("View") method.

To workaround that, I would probably create a second virtual column. So...
[New Virtual Column] App Formula would be "=[Original Column]" so they always have the same value

Then you give one column the Display name of "Payed", one column the Display Name of "To Be Payed"

Then to only show one column or the other, you could either (1) in the definition of the slice, only include the applicable column or (2) use SHOW IF logic to hide the "wrong" column for each instance.

View solution in original post

Conditional display column name for different views in dashboard