Best Of
Re: Divide numbers from same column based on criteria from another column
You can utilize a window function to pull the MAU for each month and divide your DAU by that number
MAX(CASE WHEN `category` = 'DAU' THEN `users` END) / MAX(MAX(CASE WHEN `category` = 'MAU' THEN `users` END) FIXED (BY LAST_DAY(`date`)))
Re: Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
we're currently in a situation where this would greatly improve our governance. please make this a thing, Domo!
Re: Divide numbers from same column based on criteria from another column
You can use a case statement for this
SUM(CASE WHEN `category` = 'DAU' THEN `users` END) / SUM(CASE WHEN `category` = 'MAU' THEN `users` END)
Then make sure to graph based on your date field. You can change the aggregation function if you need something different.
Re: How do I get value and Percent of total.
@ggountanis You can add the percent of total under the Data Label settings in Analyzer by writing %_PERCENT_OF_TOTAL in the "Text" box to make it appear in the card
Re: Dynamic Image for Users
yes, you can use the HTML table card to display this. You would create a beast mode that has the necessary HTML code to display the image, like this:
CONCAT('<img src="',`Profile Picture URL`,'" style="width:128px;height:128px"></>')
In this example, the full URL to the image is in the field called Profile Picture URL, but if you just have the ID, you can build the URL in the concatenation as well.
Re: How do i fill in the date gaps?
@Tina_Alpaca I created a video on how to do this in Magic ETL. You can watch it here:
https://www.youtube.com/watch?v=9iNpzSL5V6U
Hope this helps.