Hi,   I have a table with dynamic fields, some of these fields contain no value or NULL, how do I remove these fields when I dont know the field name beforehand?   The field names are never the same so I cannot simply do | fields - name1, name2 etc..   Is there are way to remove every field containing no value in a table? ... View more

Hi,  I have an alert that triggers when an employee opens a file. This alert runs every 30 minutes so we can see these alerts fast. When employee1 opens file1 we see the alert, and throttle based on the field "employee", because if we dont throttle then this alert keeps repeating every 30 minutes. Problem is now that when employee1 opens file2, file3, or file4 we do not see this anymore since we have a throttle on employee.. Is there a way to throttle on a combination of employee and file so that when employee1 opens file1 we get an alert, when he opens file2 we get a different alert, but we dont keep seeing the same alerts repeating every 30 minutes?   ... View more

Hi, I have a field called "Employee_Email". This field contains the value: ["firstname.lastname@gmail.com"] How do I remove the special characters [" and "]?   I tried:  | eval test1 = replace (Employee_Email "[" , "")   But when I tried to remove either [ or " it gives me the following errors: Error in 'EvalCommand': Regex: missing terminating ] for character class Or: Unbalanced quotes.   Is there a way to ignore the normal effect of [ and "? ... View more

Lets say we have the following data set:   Fruit_ID Fruit_1 Fruit_2 1 Apple NULL 2 Apple NULL 3 Apple NULL 4 Orange NULL 5 Orange NULL 6 Orange NULL 7 Apple Orange 8 Apple Orange 9 Apple Orange 10 Apple Orange   Now I am trying to count the total amount of every fruit, in the above example it should be 7 apples and 7 oranges, the problem is that these fruits are seperated in 2 different columns because a fruit name can be both an apple AND an orange, how do I deal with this when counting the total amount of fruit? Counting one at a time works: | stats count by Fruit_1 But how do I count both to give a total number since they are 2 seperate columns I tried combining both columns so its all in 1 long list of values in 1 column but I could not get a definitive answer on how to do this. I tried appending results so first count Fruit_1, then append count Fruit_2 but I did not get the right result of Apple: 7 Orange: 7. Its either 1 or the other. Does anybody have a fix for how to count over multiple fields like this and combine the result together in 1 field? ... View more

Under "Activity" you have "Triggered Alerts" but I cant seem to make an easy to read overview/email a PDF with these numbers. I would like to create a report of the following:   In previous month the following alerts were triggered: Use case 1: 15 alerts Use case 2: 10 alerts Use case 3: 3 alerts Use case 4: 0 alerts   I can make this manually in a dashboard but it will take a long time to do when you have 100+ use cases .. Anybody have any insights on how to create this quickly in a (scheduled) report for the previous month? ... View more