-
![Profile picture of Pete Whittle]()
Pete Whittle posted in the group Konect Manager
Looking for a tip with queries. How can you set up queries for ‘Last month’ and ‘Current month’? Thanks. @mattgbm
4 Comments-
-
![Profile picture of Pete Whittle]()
the problem is it’s a moving frame, Matt. I asked the AI bot and it said “Set Time Filters : Use the date or time filter options to specify the time period. You can select options like ‘last month’ or ‘this week’ from the available presets or manually set the date range.” – which I think is an example of AI making stuff up, as there’s no such operand.
-
![Profile picture of Matt Smith]()
Hi Pete, please send me an email about this is issues still persist. It sounds like a specific dataset question
-
![Profile picture of Pete Whittle]()
Yes OK thanks. I think it’s a case of the benefits of using an analytics tool like Power BI in conjunction with Konect.
-
-
-
-
-
![Profile picture of Pete Whittle]()
Pete Whittle posted a new activity comment
@mattgbm or others, any update on this? Could an alert be created in the API? It can be done in Power BI, but my client has not set this up yet.
2 Comments-
![Profile picture of Pete Whittle]()
We have settled on using the API and a Python script in conjunction with a messaging service like Twilio. This is being done in one Konect instance we are aware of, using Power Automate.
-
![Profile picture of Matt Smith]()
Hi Pete. Thanks for the insight, this sounds like a good approach to trigger the alert making use of the Konect API
-
-
-
![Profile picture of Russell Shooter]()
Russell Shooter posted a new activity comment
Hi Pete, if a konect dataset has a date defined you should be able create a query by using the less than function. The konect manager should give options to define a time interval