Add a custom measure or dimension and use it as a filter in a dashboard tile

I have a dashboard tile with deposit information and requires a specific filter for 'customer_first_x_days'. My approach was to create a table calculation named 'first_x_days' with the logic `diff_days(${customer.signup_timestamp_date},${deposit.deposit_timestamp_date})`

This gives me the output I want, but it doesn't allow me to add it as a filter to my tile.

How do I get my custom measure to work as a filter like in this screenshot ?

cherylt_0-1721353761269.png

 

Solved Solved
0 1 1,106
1 ACCEPTED SOLUTION

Just as I published this question, I figured it out. I needed to make it a custom dimension instead of a table calculation in order to use it as a filter. Screenshots supplied for anyone with a similar question. 

cherylt_0-1721354154118.png

cherylt_1-1721354177255.png

 

 

View solution in original post

1 REPLY 1

Just as I published this question, I figured it out. I needed to make it a custom dimension instead of a table calculation in order to use it as a filter. Screenshots supplied for anyone with a similar question. 

cherylt_0-1721354154118.png

cherylt_1-1721354177255.png