Forum Discussion
Setting alert
Anonymous I might not have been clear here. What I am suggesting is a measure that calculates an overall count for any parcels that are over 3 days. That Card visual can be placed on dashboard and will trigger an alert to be sent if the threshold you set is met. That card can then be linked to the actual page where you show all parcels that are over 3 days. 8k records is small. This solution proposal takes the aggregated amount, not on the parcel level. So I'm unsure of whether or not it meets your needs.
Anonymous I'm not aware of a row level way to do this. You can have a card on a dashboard that will send an email alert that you have parcels over 3 days. You would need some backend process to exclude them in further alerts if you didn't want to keep recieiving an alert after every refresh for the same items. If you would want that, then the card would work. I would suggest you create a report of a list of all the overdue parcels, and then when you recieve the alert you could click on the card and be taken to the detailed list of all parcels that are overdue.
Anonymous
Is it working for a large amount of data becuz i have around 8000 lines.
Also i want to ask is it possible to get the relevant project names (which row triggered the alert)?
Thanks a lot!
Anonymous I might not have been clear here. What I am suggesting is a measure that calculates an overall count for any parcels that are over 3 days. That Card visual can be placed on dashboard and will trigger an alert to be sent if the threshold you set is met. That card can then be linked to the actual page where you show all parcels that are over 3 days. 8k records is small. This solution proposal takes the aggregated amount, not on the parcel level. So I'm unsure of whether or not it meets your needs.