Jump to content
We've recently updated our Privacy Statement, available here. ×

Timeseries for last 30 days with respect ot filters


Martin Baumgartner

Recommended Posts

Hi

I'm trying to make a line chart for timeseries for the last 30 days. Using "Limit data using expression" and the dateadd-function is doing the job while the time isn't filtered.

But when the user is nowshifting the latest date back, the line chart is only updating the end-date but not the starting-date.

How can I solve this issue

Thank you in advance.

 

BR, Martin

Link to comment
Share on other sites

Limit Data Using Expression sets a "hard filter" on a visualization to make sure that certain values are never included in the calculations behind the visualization, regardless of any filtering in the Filters panel.

Reference: https://docs.tibco.com/pub/sfire-analyst/10.8.0/doc/html/en-US/TIB_sfire...

As a workaround, you can use two sliders (one for start date and one for end date) from property controls in a text area and modify the custom expression with the document properties associated with those two sliders.

Please refer to the attached analysis file. I have associated the second slider only and you can modify it accordingly.

Please note that you can accomodate only 1000 values in a property control so I have added a calculated column with only Date (and not time) to fit all the Date values in the slider.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...