Stack Overflow
Stack Overflow

Questions tagged [retention]

When data is to be retained, downsampled, or eliminated from a: database, filesystem or other storage device use 'retention'.

203 questions
1
vote
1 answer

Retention Rate within Cohort

I want some cohort analysis on a userbase. We have 2 tables "signups" and "sessions", where users and sessions both have a "date" field. I'm looking to formulate a query that yields a table of numbers (with some blanks) that shows me: a count of…
user3600097
  • 35
  • 4
1
vote
1 answer

MDX how to count visited users in yesterday exist visit today

I have a fact table to store user login date_key | user_key 20140701 | 1 20140701 | 2 20140701 | 3 20140701 | 4 20140702 | 1 20140702 | 2 20140702 | 3 20140702 | 8 20140703 | 1 20140703 | …
Coca'sPP
  • 13
  • 2
0
votes
0 answers

How to set "Retention Period" + "Vacuum" for Delta Tables in Azure Data Factory refreshed by a CDC Pipeline... without using Data Bricks

Key Issue: CDC (preview) in ADF has no "Vacuum" or "Retention Period" setting to delete outdated parquet versions / trim Delta Logs for Delta Tables I am using Azure Data Factory's Change Data Capture feature (currently in Preview) to incrementally…
ashap551
  • 23
  • 1
  • 6
0
votes
1 answer

Calculating returning active users SQL

I am running a query that returns the count distinct of active users per different products grouped by day and country. I also added two columns 'previous_day_active_users' and 'returning_users' which return the number of users active in the…
Steven
  • 19
  • 3
0
votes
0 answers

Changing retention policy is not taking effect

The end goal is to have logs in Loki for 1 year. The configuration of the instance is as follows: schema_config: configs: - from: 2020-10-24 store: boltdb-shipper object_store: filesystem schema: v11 index: …
user22188956
  • 13
  • 3
0
votes
0 answers

How to remove deleted log lines in Loki Grafana

I have a Promtail instance that reads log files and sends them to a Loki instance. When a new log line is generated, Promtail sends it to Loki, and it appears as a new log line in my Grafana dashboard, which is great. However, if my application that…
Etienne
  • 1
  • 2
0
votes
1 answer

Set lifecycle rules based on last accessed in Azure storage

Is it possible to natively set a life cycle policy to delete files not accessed since X-days? If not, is there a possible to use the blob API for that? PS: I don't mind whether to use v2 data lake or regular blob storage
Bennimi
  • 416
  • 5
  • 14
0
votes
0 answers

Keycloak user session retention after restart

We are using keycloak 18 and we have not enabled ispn cache & now we have close to 15000 users sessions logged in to our application. To enable ispn cache we have to restart the instance and all 15k users sessions will be lost, is there a…
shivanand patil
  • 1
  • 1
0
votes
1 answer

ADX Table specify UTC time in policy retention period

Is it possible to specify a UTC time when deleting data in a table in Azure Data Explorer? For example: My Table is constantly being ingested with an Event Hub. I want my Table retention policy to only keep data from 00:15:00 UTC to 00:15:00 UTC of…
Alejandro Alvarez
  • 131
  • 1
  • 3
  • 9
0
votes
1 answer

Get backup schedule and retention (short and long term) for SQL Servers using Azure Resource Graph Explorer

I am trying to get the backup schedule and retention for SQL Servers using Azure Resource Graph Explorer. I am unable to find any such information. The current query that I have is resources | where type == 'microsoft.sql/servers' I am trying to…
arun_mitt
  • 1
0
votes
0 answers

Does calculating a YTD retention rate inflate the actual retention rate when the contracts are annual contracts?

I have seen a lot online about calculating Retention rates all articles seem to post the same equation: ((E-N)/S) * 100 Where E is the number of active contracts at the end of a period, N is the new business in that period and S is the active…
jackdotdi
  • 24
  • 3
0
votes
0 answers

How can I store processes metrics data for a longer time beyond the default 24 hr retention period in GCP ops agent?

Currently there is only 24 hrs retention period for all processes metrics collected by ops agent in gcp. As per the documentations no configuration changes can be made to change this default value. Is there any other way to increase it's retention…
Babli Sahu
  • 21
  • 3
0
votes
0 answers

Showing details of 'Lapsed' customers in a given month in Power BI

I'm trying to build a Retention Analysis piece on a Power BI dashboard and would like some help in diving deeper into the visuals I've already built. The green bars show the total customers served in each month and the black bars show the number of…
beginnerprogrammerforever
  • 77
  • 5
0
votes
0 answers

Why does my retention rate have such strange values in bigquery but normal in GA4?

I can’t find a solution to the problem anywhere, even the great ZhPT can’t cope yet!) Maybe someone here has encountered a similar problem, I would be very grateful! Data from Google Analytics 4 (GA4) is fed into bigquery. There, an SQL query is…
Slava
  • 1
  • 1
0
votes
0 answers

get daily user retention (Hive)

I want to get daily user retention. (Hive) I have the user's login history. Based on the search date, I would like to find the number of users who accessed from D+0 to D+4 days. (If you haven't logged in even one day, it considered to have…
Haim
  • 1
  • 2
1 2 3
…
13 14