[From Wrike] Wrike Analyze: The Advanced Filters Strike Back

ร‰pinglรฉe En avant

Hi Community!

I'm Herine, your friendly expert in Wrike Analyze. I'm here to guide you through taming this powerful tool! ๐Ÿ˜Œ

ย 

Are you an advanced Wrike Analyze user searching for ways to expound on data filtering?

In this post, I'll unravel the intricacies of advanced filters for use cases such as:

  • Sorting tasks/projects planned for the last, current, or upcoming month
  • Inspecting task/project backlogs active within a certain past timeframe

ย 

Walk with me as we dive into how to combine different types of filters using AND/OR logic, such as a timeframe filter meshed with a list filter. But before we jump in, make sure you've brushed up on themes from Advanced filters with offsets in formulas ๐Ÿ”Ž ย by Mobeen.

ย 

Use case: OR operator to revealing Past and Future Dates

Buckle up as we're about to venture into more hardcore territory ๐Ÿ˜

ย 

Do you wish your widget could reveal tasks scheduled for the previous, current, and next month? Sure, you could manually filter this in the Calendar or List tabs, but what if you want to keep your filter dynamic? I've got your back - let's tweak it in the Advanced tab:

  1. ย Go to the tab Timeframe and select โ€œLast 2 monthsโ€
  2. ย Switch to Advanced and change offset from 1 to 0 (to include the current month), and nab that script
  3. Copy the script

  4. Switch back to TimeFrame and select โ€œNext monthโ€
  5. Return to Advanced
  6. Add ย { "or": [ ย to the beginning of the script
  7. Add a comma ย to the end of the script
  8. Paste the script copied earlier
  9. Add ] } to the very end of the joint script

P.S. - the ย "custom": true part will be added automatically to the script when itโ€™s saved, thereโ€™s no need in adding it manually.

{
ย "or": [
ย ย ย {
ย ย ย ย ย "last": {
ย ย ย ย ย ย ย "count": 2,
ย ย ย ย ย ย ย "offset": 0
ย ย ย ย ย }
ย ย ย },
ย ย ย ย {
ย ย ย ย ย "next": {
ย ย ย ย ย ย ย "count": 1,
ย ย ย ย ย ย ย "offset": 1
ย ย ย ย ย }
ย ย ย }
ย ],
ย "custom": true
}

ย 

I would also like to share one of the use cases I was working on for my own reports.

ย 

Use case: task backlog - last quarter

Wrike Analyze's lack of generic date dimensions doesn't halt our progress in reporting on backlog. Let's delve into how I arranged the backlog for the last quarter using the mighty advanced filters!

ย 

Let me first define the backlog in my use case: I want to see all the tasks that the team was working on during the last quarter, meaning they should have been active at least one day. This translates to:

  • Tasks created -> Last Quarter or earlier
  • Tasks completed -> Last quarter OR N/A (not completed yet)

Here's how the first filter setup looks: I selected โ€œLast 2 Quartersโ€ in the Timeframe tab, then amended the '2' to '20':

ย 

20 quarters = 5 years, I have no tasks created earlier, so this filter will show everything created before this quarter. You can go a step further to 200 quarters to be absolutely sure! ๐Ÿ˜‰

Now, let's piece together the filter for Completed Date, using a similar logic from before but tossing in scripts for both List and Timeframe tabs - here's the wizardry:

  1. Filter Timeframe to This Quarter
  2. Switch to Advanced and copy the script
  3. Switch to List and filter it to N/A
  4. Go back to Advanced and add the copied pattern, separated by a comma
  5. Insert { "or": [ to the beginning of the script and ย ] } to the end.
{
ย "or": [
ย ย ย {
ย ย ย ย ย "last": {
ย ย ย ย ย ย ย "count": 1,
ย ย ย ย ย ย ย "offset": 0
ย ย ย ย ย }
ย ย ย },
ย ย ย {
ย ย ย ย ย "explicit": true,
ย ย ย ย ย "multiSelection": true,
ย ย ย ย ย "members": [
ย ย ย ย ย ย ย "N\\A"
ย ย ย ย ย ]
ย ย ย }
ย ],
ย "custom": true
}

Hereโ€™s what my test widget on the team backlog for the last quarter looks like:

ย 

This approach can be used with other types of filters as well. If you need to use the AND operator rather than OR, the structure would be the same, except that youโ€™d need to use { "and": [ instead of { "or": [.

ย 

I trust this wisdom has unlocked new realms of customized reports for you! ๐Ÿ˜„

Excited to know how these tips benefit you - please, don't hesitate, share your remarkable scripts and solutions in the comments!



Herine Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalitรฉs et les meilleures pratiques grace ร  nos Webinaires online

Herine Wrike Team member En savoir plus sur les fonctionalitรฉs et les meilleures pratiques grace ร  nos Webinaires online

8
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
2ย commentaires

Thanks Herine! Very Useful!

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

This is great!ย  I like how Wrike is teaching us how to self-serve different reporting capabilities.ย  Keep it up Wrike!ย 

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Folllowing List for Post: [From Wrike] Wrike Analyze: The Advanced Filters Strike Back
[this list is visible for admins and agents only]

Haut de la page
Didnโ€™t find what you were looking for? Write new post