Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to divide data from two different data sources

Hi All, I am hoping you can help me out with the below query.

I have two data sources that look as below;

 

Table1

 

Table2

 

From 'Table1' I've created the below table;

 

From 'Table2' I've created the below table;

 

Now, I want to divide the sum of dailycount from Table1 with the count of userId per month from Table2.  e.g.   8/173,876 * 100 = 0.01%

 

My goal is to achieve the below table with the percentages of total;

Thanks,

 

Need Help

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    Create a measure, and then set two variables, the first variable to get the total of each name in each month, and the other variable to get the total of the UserID corresponding to the name in each month, and then divide them.
    If you need more help, please share the sample file or sample data.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.