Data table limited to 6 rows

[Alexander Baverstock]

Hi guys,

Wanting to know how I would limit the table to only the first 6 values Being 1m,2m,3m,4m,5m,6m etc. Not 6 1Ms etc

I Cant seem to do this limiting or adding rules.

Cheers

[Shashank Gurnalkar]

Add this expression in Properties >> Data >> Limit data using expression:

[Date] = First([Date])Let me know if this helps.

[Alexander Baverstock]

Cheers Shashank, sadly doesnt work, "first' is not an available, any other ideas

[Shashank Gurnalkar]

Alex, it looks like you are using External data in which case there are limited functions available. Unless I know the data source and the available functions, I won't be able to help you. My logic was to get the data where [Date] column is equal to the First([Date]) which is 13/07/2017. If you can get a similar function with respect to the data source you are using, and use it in the custom query you will get the desired result.

 

Custom Query Reference:

 

https://docs.tibco.com/pub/sfire-analyst/10.3.3/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connect/connect_what_are_custom_queries.htm