![]() SELECT sum(donationsum)/count(donation id) AS sum, quarter(date) AS quarter2 Order by date year asc, quarter(date) asc SELECT sum(donation sum)/count(donationid) AS sum, quarter(date) AS quarter1, concat(date year, " - Q", quarter(date)) AS Spendenquartal SELECT Spendenquartal, t2017.sum AS Durchschnittspende 2017, t2016.sum AS Durchschnittspende2016, concat(round(()/t2016.sum*100), “%”) AS Wachstum zumVorjahr WHERE "public"."ahoyevents"."properties"::json->'category' like '%server%' WHERE "public"."ahoy events"."properties"->'category' is not null WHERE NOT (lower("public"."ahoyevents"."properties"->'category') like '%server%') ![]() WHERE "public"."ahoyevents"."properties"->'category' is not null WHERE (CAST("public"."ahoyevents"."time" AS date) BETWEEN CAST((NOW() + INTERVAL '-7 day') AS date)ĪND CAST(now() AS date) AND NOT (lower("public"."ahoy events"."properties"::json->'category') like')) GROUP BY "public"."ahoyevents"."properties"->'category' WHERE (CAST("public"."ahoyevents"."time" AS date) BETWEEN CAST((NOW() + INTERVAL '-30 day') AS date)ĪND CAST(now() AS date) AND NOT (lower("public"."ahoy events"."name") like ?)) ORDER BY "public"."ahoyevents"."name" ASC WHERE (CAST("public"."ahoy events"."time" AS date) BETWEEN CAST((NOW() + INTERVAL '-30 day') AS date)ĪND CAST(now() AS date) AND NOT (lower("public"."ahoyevents"."name") like ?)) ![]() SELECT "public"."ahoy events"."name" AS "name" WHERE NOT (lower("public"."ahoy_events"."name") like ?) SELECT "public"."ahoy events"."id" AS "id", "public"."ahoyevents"."name" AS "name", "public"."ahoy events"."profileid" AS "profile id", "public"."ahoyevents"."properties" AS "properties", "public"."ahoy events"."time" AS "time", "public"."ahoyevents"."user id" AS "userid", "public"."ahoy events"."visitid" AS "visit id" ORDER BY "count" DESC, "public"."ahoy_events"."name" ASC WHERE NOT (lower("public"."ahoy events"."name") like '%server%' SELECT "public"."ahoy events"."name" AS "name", count(*) AS "count" GROUP BY "public"."ahoy_events"."properties"->'category' WHERE CAST("public"."ahoyevents"."time" AS date) BETWEEN CAST((NOW() + INTERVAL '-7 day') AS date) SELECT "public"."ahoy events"."properties"->'category' AS "propertiescategory", count( ) AS "count" SELECT "public"."ahoy events"."properties"->'url' AS "propertiesurl", count( ) AS "count" ![]() "public"."ahoy events"."visitid" AS "visit id", "public"."ahoyevents"."profile id" AS "profileid", "public"."ahoy events"."userid" AS "user id", WHERE "public"."ahoy_events"."name" = '$view' "public"."ahoy events"."visitid" AS "visit id" "public"."ahoyevents"."user id" AS "userid", "public"."ahoy events"."properties"->'url' AS "propertiesurl", "public"."ahoyevents"."properties" AS "properties", SELECT "public"."ahoy events"."id" AS "id", "public"."ahoyevents"."name" AS "name", "public"."ahoy events"."profileid" AS "profile id", "ahoyevents"."properties"->'page' as "page" "ahoy events"."properties"->'url' as "url", ORDER BY "public"."ahoy_events"."properties"->'url' ASC GROUP BY "public"."ahoyevents"."properties"->'url' SELECT "public"."ahoy events"."properties"->'url' AS "propertiesurl", count(*) AS "count"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |