What I also want to go is for the user to click on the calculated field number and it pulls up in different table the reference numbers where the update_time_JD_1 field is for exmpale Less than 3 Days (in hours). Can this be done?

Re: Creating a table with Manual Text Rows and Calculated Field Rows

if(update_time_JD_1>=30/24 and update_time_JD_1 < 50/24,'Last Updated more than 3 days ago',

if(update_time_JD_1>=50/24 and update_time_JD_1 < 100/24,'Last Updated more than 5 days ago',

if(update_time_JD_1>=100/24 and update_time_JD_1 < 140/24,'Last Updated more than 10 days ago'))) as LastUpdated

from ...mysource...;

If you click on a value of an expression then the dimension values of that row are selected. So that's not going to work. However if you create the field LastUpdated in the script users can select a value in that field and you can show the related details in a separate table.

Re: Creating a table with Manual Text Rows and Calculated Field Rows

Yes, I also suggested that one can add the field to the script if the classification is static (as it seems in this example).

But why shouldn't above work in principle?

If you select a dimension value in the table, I believe the selection will basically be done on the aggr() dimensions values involved, i.e. selection will be done on update_time_JD_1, which seems just what is needed here.

Re: Creating a table with Manual Text Rows and Calculated Field Rows

Oh, I hadn't seen your response yet. No arguments from me regarding your first response. I wouldn't dare :-). My post was a reply to Jonathan, not to your post. Selecting a value in the calculated dimension works fine afaik. It's just that selecting a value in the expression won't work. I understood 'calculated field number' to mean a result value of the expression.

Re: Creating a table with Manual Text Rows and Calculated Field Rows

pHi All,

I tried your replies but Im still having issues. I think the issue I have is the way I have built my load script. Would you mind having a look at the load script and seeing where I can put your answers as when I enter it in the load script I keep getting a message saying: update_time_JD_1 does not exist.