Divide count of Table 1 by count of Table 2 on the same time interval

0 votes

I have two tables with ID and time stamp. Table 1 has two columns: Cust_id and cust_created. Table 2 has two columns: Cust_id and post_date. I'd like to create a chart in Tableau that displays the Number of Records in Table 1 divided by Number of Records in Table 2, by week. 

Apr 11, 2018 in Tableau by GandalfDwhite
• 1,320 points
13 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Use a custom SQL to create a new data source

SELECT created_table.created_date,
   created_table.created_count,
   posted_table.posted_count
FROM (SELECT TRUNC (cust_created) AS created_date, COUNT (*) AS created_count
      FROM Table1) created_table
   LEFT JOIN
   (SELECT TRUNC (post_date) AS posted_date, COUNT (*) AS posted_count
      FROM Table2) posted_table
       ON created_table.created_date = posted_table.posted_date
answered Apr 11, 2018 by QueenBee
• 1,810 points

Related Questions In Tableau

0 votes
1 answer

Filter Measure Based on Different Variables of the Same Dimension

Hi Nithin, I used calculated fields. You can use ...READ MORE

answered Mar 11 in Tableau by CHERUKURI
• 12,420 points
8 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,170 points
69 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
1,839 views
0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in ...READ MORE

answered May 16, 2018 in Tableau by Mathew1810
60 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,170 points
897 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,170 points
35 views
+2 votes
1 answer
0 votes
1 answer

Apply filters only on the dashboard

First of all why??? Second of all, it ...READ MORE

answered Apr 13, 2018 in Tableau by QueenBee
• 1,810 points
13 views
0 votes
1 answer

Return last day of each moth in the calendar

Try this way: Place the order date in ...READ MORE

answered Apr 20, 2018 in Tableau by QueenBee
• 1,810 points
15 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.