One single filter for all dates with different fields

Q&A
,
1

image
image1297×181 12.1 KB

Hi team, I have different time fields in my database which will lead to separate filters on the date/time as shown above. I tried to use parameter applying to all filters, but not sure how it works. May you guide me on how to integrate them into one single filter? Thank you

2

Hi @heichitc

I did not clearly understand what you are trying to do looking at your screenshot.

Can you please elaborate your requirement a little further and may be take an example for one of your many fields and explain?

3

Hi @heichitc ,

I am assuming you are trying to apply the same parameter filter to all dates but want to check if any of the condition fulfills. Instead of adding it under the filter, you can create a calculated field with OR conditional check, if you are intending to filter likewise. And use the same calculated field as filter. This works with AND conditional check as well.

If you use all date fields as filter in filter pane, it will also work but it will be AND conditioning- when all fields meet the filter criteria.

Based on your use case, you can choose the way to implement.

Thanks,
Prantika

4

Hi team,

yes, I’m looking for setting up a single all-in-one filter which can apply to all the 7 date fields , so that users do not need to edit the date one-by-one to filter different periods. Provided that there are two individual datasets involved, even using “OR” in calculated fields may not be able to join all the fields.
In addition, may I know do you mean like this when I’m trying to create the calculated field using “OR”? But error pops up when saving.
image

5

Hi,

I would recommend using a coalesce calculated field, if you have one date in one column from one dataset, and another date in one column from another date, that are not directly joined. Normally, then you have all the date in one column through the calculated field.

I hope this can help you!

6

By OR conditional check I am suggesting something like :

ifelse( {datefield1}=${dateparameter} OR {datefield2}=${dateparameter} …, 1, 0)

In that way we are checking if either of them matches the selected date.

For individual datasets, you can use the same method of creating one calculated field for each datasets to create conditional checks.

7

Hi @heichitc,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post or did one of the solutions provided above help with your case?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

8

Hi @heichitc,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you