Hi,
I'm trying to create a time filter that will only ever return current month and December 2020. I've managed to create a filter for both using separate line items, struggling to combine and allow users to view.
Any suggestions?
Thanks.
Hi @hinamahmood1994
You can try this:
1. Add one line item to combine the both condition current period & december 2020 filter
2. In your target module use this as a filter
Hope this helps!
Thanks
Akhtar
You could do this by creating 3 line items
A. One which contains the logic for Current Month boolean format & time dimensioned - ITEM(TIME) = Current Month
B. One which contains the logic for December 2020 boolean format & time dimensioned - I wouldn't recommend hardcoding so maybe a line item where you choose the month by boolean (so this is really a setting)
C. One which combines the logic boolean format & time dimensioned = A OR B
I hope this helps!
Usman
Thank You! I was using And to combine my two line items instead of OR.
Hina 🙂
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
