Forum Discussion
RANKX By Group In Measure for Push Dataset
kbsmx I don't think there is anything you can do about it, if data is not in the dataset, what you want the expected behavior to suppose to be?
- kbsmx5 years agoFrequent Visitor
parry2k - The data *is* in the dataset. Basically what I want to do is show the latest set of rows for a given site. That's why I'm trying to find a way to have the visuals show the latest data *per site*. This way if some site has been updated to a later date, the *latest* date of another site will still be shown. This would ensure that the user didn't see the missing sites simply because only the latest date was being used across the entire dataset.
This also protects against a failure of the push dataset refresh process. If the process that pushes the data to the push dataset fails to run properly, the most recent successful data pushed will still be shown. If you just go with a sliding date filter across the entire dataset (which is the way this is behaving), you'll show either an incomplete set of data (as shown above) or no data at all (in the case of a data push failure).