Hi,

I tried to use a calculated field i made in the report level (using FreeSQL option ) as a Filter but could not put the field in the filter section.

I used a simple DateAdd function on a timestamp field and tried to use it as a filter.

I tried to do the same in the View level but still yellowfin client dosnt enable me to use it in the filter.


the only way i found that works is to make a virtual table with the same function as one of the columns and connect the table with join to the rest of the tables in the view. only then Yellowfin enables me to use the new field (from the virtual table) as a viable filter.

this solution is "ugly".
Creating virtual tables for calculatd fields is not the way to go i think. especially when i have several calculations in mind on columns from diffrent tables. Is this the way to solve this?

Here a Video showing the problem

LINK

I am using Yellowfin 7.1 build 20141029

I will appreciate any help on the matter

Thanks

Shaul