I added a row with a “1” (same solution with “count”) as each row is the visit of one dashboard.
I tried to show a month over month click rate. (of course I adjusted my date function with trunc date and “adddatetime”)
Hello @eddie1995, welcome to the QuickSight community!
If you want a month over month trend, I would say you have 2 options here. If you want to utilize a periodOverPeriod function to get the difference from month to month, I would avoid using a QuickSight calculated field as your value, and try doing this instead: periodOverPeriodDifference(distinct_count({log in}), {Date}, MONTH, 1)
You wouldn’t even have to use truncDate in this instance because it will take the total number of distinct logins for each month and show you how much higher or lower each month is. Now if you just want the total number for each month, I would try something like this: distinctCountOver({log in}, [{Date Month}], PRE_AGG)
This 2nd function does need to have the Date field aggregated to month values, but now this will give you the total distinct log ins for each month.
I’ll mark this as the solution, but let me know if you have any follow-up questions!