on 03-13-2024 10:05 AM
Hi all, we are trying to create a story using the ACTIVITY_LOG model which is a live model within SAC that is used to show info in the system overview.
Using this model as base, we created a story(2.0), in it we have a table, measures and dimensions from the model were selected and data is displayed, but when the date filter is set using "Date(Range)", no data is visible, were as when a date filter is set using "Date(Member)" data is visible, so is there any limitation in setting a range date filter when the story is based on a liver model. What we wanted was to set the filter for date dynamically to show the previous 30 days of data using the system date as the base.
Any help in this regard would be greatly appreciated.
Hi akhilgs,
when adding the Date (Range) filter I experienced the same problem when using the 'Date (Range)' parent note. However, when expanding the node and choosing the child 'Date (Range)' filtering works as expected. Does that work for you?
br
edgar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi akhilgs,
Could you share an image of your table and Builder?
I was able to use activity_log in combination with a date range filter (last 30 days from system date):
br
edgar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, @eeddggaarr thanks for your reply, please check the below screenshot with Date(Member) filter set to March 2024, data is showing
Below is the screenshot with the Date(Range) filter set, no data is showing
I have tried setting a date range filter for the table, tried to set it as a story filter, still nothing.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.