Datagroup is not working

[anbuselvan]

Hello Looker Support Team,

I hope this message finds you well.

I am currently facing an issue with my scheduled report delivery. I have a report set to be delivered every day at 03:30 PST. but the datagroup is stop triggerring and its not working for last 33 days.

The problem is that the datagroup from lookml is not triggering for last one month.

Could you please assist me in resolving this issue? Any help or guidance you can provide would be greatly appreciated.

Thank you in advance for your support.

[GavinW]

Can you please share the code for your datagroup here? 

[anbuselvan]

datagroup: transaction_summary_datagroup{
description: ""
max_cache_age: "24 hours"
sql_trigger: SELECT count(*) FROM `Table`
where Instance_Name='XYZ' and Average_time>0.3;;
}

[GavinW]

The sql_trigger_value works by triggering the datagroup when it runs and returns a different result to the previous run. You can read how it works here. My guess is that if you run that query against your database, it will return nothing, so the value returned will never change.

You can see examples here of what the query should look like.