Working in workflow - i need an expression that will look at data - but will not send data if it is a duplicate of data.
Example:
Table A has column - [Location]
I want the expression to send data once PER [location]
Probably, but your problem description is confusing.
Sorry.
If my table A looks like this:
[Location] [DSO]
Bmt 19
Bmt 19
Bmt 19
Baton Rouge 25
Baton Rouge 25
In this example - i would only want Bmt DSO - 19 sent ONE time
Does that make sense?
So you want only the distinct values,or distinct pairs in this case.
You need a template expression?
I want a workflow rule - so it can fire off a โMove data to another table with a new rowโ - using this data.
So the new row added to my other table will be:
[Location] [DSO]
Bmt 19
But only once. Not the three rowsโฆ
One workflow rule is not aware of the activity of other workflow rules, except as reflected by the data in your tables. So, for instance, if you update three rows in short order, thereโs no inherent way for the workflows to know that there are three changes to handle and that some process should only be done once.
oh ok. So how would i get this process done?
Impossible to say without knowing the details of you process.
Ok. The Table A - i have been referencing looks like this:
[Sales Territory] - is basically - [location]*
In the table in my app - i have a VC:
This gets me DSO per [location]:
I want to move that view of values - to another table. But I only want one row PER [location]
***In the above view - there IS only one row showing - but if you click on it - it will show all the rows showing same data per [location]
Do you currently have a table that has one row per branch? Maybe a Branches table?
Yes. And I currently have a button - that can send a row to it. But i have to do this manually and I want it done automatically at a certain time of day:
But how do i make it ONLY send one row? Meaning - send only one row per location?
Do you currently have a table that has one row per branch? Maybe a Branches table?
Oh, sorry. Yes:
Hmm. Well, below are the actions you need to generate the report rows, but thereโs no way to perform an arbitrary action from a report unless the report is run against each row of the table. So to schedule a report to run only one a day that generates data rows, youโll meed a table or slice with exactly one row and run the report against that row.
[Key]
SUM(
SELECT(
table A[DSO],
AND(
ISNOTBLANK([Sales Territory]),
([Sales Territory] = [_THISROW].[Key]),
...
)
)
)
ISNOTBLANK(
FILTER(
"table A",
AND(
ISNOTBLANK([Sales Territory]),
([Sales Territory] = [_THISROW].[Key]),
...
)
)
)
branches-table[Key]
TODAY()
"Total"
SUM(
SELECT(
report-table[dso-column],
AND(
([date-column] = TODAY()),
NOT("Total" = [dso-column])
)
)
)
Thanks Steve,
I am running into this error?
Whoops! I should have explained! These dots:
represent whatever other conditions you need to add to select the appropriate rows for the sum. For instance, to heck the date. Replace the dots with any other conditions as appropriate.
OH. I gotcha. Sorry iโm stupidโฆ
I did something wrong. I think i didnโt use a slice? I got like 1000 new rows It should have been like 11
What do the new rows look like? Screenshot?
I deleted them - they kept comingโฆ
Oh i did notice also - the DSO was wrong for each - except โTotalโ
Time to troubleshoot. Make sure each actions is NOT set to Do not display. Then go to the branches table and invoke action 1 for a few branches. Do they produce the report rows youโd expect for each branch?
Ok. but i think i see a problem. Branches Table - โLocation Tableโ - i use as a ref only. It is read only. I never add data to it nor delete anything in it.
So this table should never see added/deleted/updated data:
Thatโs fine. The actions only get information, not try to add/change anything to/in it.
Weird - it just sits thereโฆ:
Ok. So i forced it to sync:
That number is wrong. It should be identical the that one above it - i ran that this morning
I wanted to add. I already do math inside the [DSO] VC:
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |