Hi! I'm trying to visualise the column anomalies r...
# community-support
a
Hi! I'm trying to visualise the column anomalies results into a custom dashboard using elementary models. However, I'm unable to find the rows related to the test in
elementary.data_monitoring_metrics
Could you please advise
Copy code
- name: total_users
        description: "The total number of monthly users"
        data_tests:
          - elementary.column_anomalies:
              column_anomalies:
                - sum
              dimensions:
                - country_code
I can see that the test is running and storing results in
elementary_test_results
as generic test but no corresponding record in
elementary.data_monitoring_metrics
n
Hey Ankit!
elementary_test_results
doesn't have a key connection to
data_monitoring_metrics
, but you can connect the column
detected_at
from the first one to
created_at
from the second one. We'll keep talking in DM to understand how you can use the Elementary report instead of building a new visualization 🙂
a
Thanks @Noya Offer I was expecting metric_name, metric_value of column anomalies to be in
elementary.data_monitoring_metrics
but there isn't in this case.