Can I use calculated fields as a filter?
16 April, 2014
In the view editor, I have created a calculated field based off an existing field using freehand SQL.
It displays perfectly as a column in a report. I now want this to be used as a filter but it won't allow me to drop it into the filter box.
Can I use calculated fields as a filter?
It displays perfectly as a column in a report. I now want this to be used as a filter but it won't allow me to drop it into the filter box.
Can I use calculated fields as a filter?
Hi,
Yes you can use calculated fields as filters.
Make sure that you are running the latest version of Yellowfin to do this.
Regards,
Stephen
Yes you can use calculated fields as filters.
Make sure that you are running the latest version of Yellowfin to do this.
Regards,
Stephen
I am using version 7.
I've done more testing, if I create a calculated field in the report then yes it allows me to use it as a filter.
But I have created the calculated field in the view editor. Now I want to use it as a filter and it won't allow it.
I've done more testing, if I create a calculated field in the report then yes it allows me to use it as a filter.
But I have created the calculated field in the view editor. Now I want to use it as a filter and it won't allow it.
Thanks for the extra info Emma.
You can actually create a 'filter' calculated field at the view level which can then be dragged into the filter box at the report level.
Please let me know if this doesn't give you what you were after.
Regards,
David
You can actually create a 'filter' calculated field at the view level which can then be dragged into the filter box at the report level.
Please let me know if this doesn't give you what you were after.
Regards,
David
That is interesting and I hadn't noticed that but I think I need a freehand SQL filter. But my SQL statement is too complex for the simple formula builder.
The SQL that I want to use is:
CONVERT('DATE', REPLACE(CONCAT("S/A Sales History Detail"."POST PERIOD",'-01'), ' ',''))
This SQL statement works and displays correctly but I can't use it as a filter which is really important.
The SQL that I want to use is:
CONVERT('DATE', REPLACE(CONCAT("S/A Sales History Detail"."POST PERIOD",'-01'), ' ',''))
This SQL statement works and displays correctly but I can't use it as a filter which is really important.
Hi Emma,
Ahh.. sounds like your stuck.
The only other think you could try is to create a virtual table.
Maybe you could also think about using a freehand SQL report?
Regards,
David
Ahh.. sounds like your stuck.
The only other think you could try is to create a virtual table.
Maybe you could also think about using a freehand SQL report?
Regards,
David