Topics started by Meitar007
There is a ‘company’ table. This view joins to a ‘content’ dt that includes the number of content that a company created each week from the day the company created. I used the ‘date_diff’ function to calculate the week duration between the ‘company_create_date’ to the ‘content_create_date’:The ‘company’ table is also joined to a ‘view’ table that includes all the number of views that a company has in the contents they created, each week from the day the company created. I used the ‘duration’ function to calculate the week duration between the ‘company_create_date’ to the ‘view_ts’: I want to create one table including these 2 tables. When I tried to do that, this is what happened:The week numbers are not synched. Please help me to think of another way to create this table
I created a derived table that count the leads that we got in each day:Instead of that, I want to count the number of the leads we got each MONTH. For that I need to cast the dates to a different format (MM-YYYY). I tried to use the FORMAT function, but the query failed: Do you have any suggestions? other solutions?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.