Discussion Feed

Hi Jesse   As you noticed when you use the following query as a metric SELECT distinctcount(appkey) FROM browser_records   It will give you a count of the number of apps that have received data in the last 5 minutes only, if there is no data in the last 5 minutes for any of the applications, it will not show and count those.   If any of the apps don't have any data it wont give you anything   What you can do to bypass this is to add a condition e.g where I put a condition that it counts all data that's less than the year 2040, or you can build a condition to just check what data timestamps is less than now() SELECT distinctcount(appkey) FROM browser_records WHERE eventTimestamp < 2232636067000 This forces the query to check all data in the analytics cluster, not just the last 5 minutes   However, depending on how long you store your analytical data, e.g if you only store data for 2 weeks, and one of the applications does not have any reported data in analytics, that app will not be counted as there is no data for it.   Hope I am making sense ... View more

Hi there   You need to explicitly set the data types per field for this not to occur:)   I just used string for all your fields in your query, however if some are Integers etc., you can update it accordingly   SELECT toString(segments.userData.CustomerName), toString(segments.userData.CustomerNumber), toString(segments.userData.Agreement), count(segments.userData.CustomerName) FROM transactions WHERE toString(application) = "TruckCare-CustomerProfile" AND toString(segments.userData.CustomerName) IS NOT NULL ... View more

Hi there   You can use regular regex, for below the following should work   https:\/\/www.abcxyz.com\/app\/#\/app\/account\/(.*)\/overview   https:\/\/www.abcdef.com\/app\/#\/app\/account\/(.*)\/overview ... View more

Hi There   You can't use the same agent to do that, however what you can do is to just install the db agent as many times as you need on the same VM, each pointing to a separate AppD Controllers ... View more