You can specify either ascending (. This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop. Amazon QuickSight is a cloud-scale business intelligence (BI) service that you can use to deliver easy-to-understand insights to the people who you work with, wherever they are. Make the calculated field: distinctCountOver (TYPE, [ID],PRE_FILTER) -1. userwith100percentcompletion: distinct_countIf. Steve. For example id. I need the total no of distinct resources launched by district users. Creator II. The date dimension over which you're computer PeriodOverTime calculations. Non-blocking right pane for secondary experiences like filters, threshold alerts, and downloads. Thanks for the reply @David_Wong - the calculated field “Ratio” is calculated as follows: “ifelse(${RatioDesired} = ‘Job Level Distribution’, {JOB_LEVEL. It shows the overall and average evaluation score,. 1. QuickSight auto-maps fields across data sets by their name and type, and applies this mapping to filter on all mapped fields coming from multiple data sets. User1 - 9e4 (1), User2 - 538 (1), User3 - 538 (1), b48 (1), c22 (1), c2e (1), f5c (5 times attempted, but as it is unique I need to count it as 1)I have a dashboard in Quick-sight where a table is being used which contains a field that has values list aggregated. Add Profit Ratio to a KPI visual. 1- check the count per asin with runningCount (asin, [date ASC], [asin]) in order to have a row count per asin. So if you made a bar chart with key as the x-axis and this count as the y it should show one on the y-axis for every x-axis point. 4. It allows you to easily embed rich interactive dashboards to your. Hi Joshua - it would be similar to the last 90 days calc, but use 7 as the number and return the field you want to do a distinct count of instead of Sales, and return NULL instead of 0. off; So I need all ids with status-1. When I take the average value of the Age column then Employee 1 and 4’s ages are twice in data, giving me an average age of 41. A new histogram initially displays ten bins (also called buckets) across the X-axis. Question & Answer calculations, howto Ahmed_She March 30, 2023, 3:22pm 1 Hello everyone, I’m trying to create a calculated field using the distinctCountOver. Amazon QuickSight Community Getting percentages of total from a count distinct. Condition#1 -> Equals Value - > GREEN (in the right check box 'color', I choose green colour) Add Condition Condition#2 -> Equals Value - > RED (in the right check box 'color', I choose red colour) Attaching screenshots for your. Connect QuickSight to many different sources. What's the equivalent function on Quicksight like "Countifs" on Excel? I would like to create a calculated field to add the count if Order status = Created AND Order status = Paid. Ideally, this would be drillable too, so a user could drill down to the week or day view but preserve the year-over-year view. minOver ( sum ( {Billed Amount}), [ {Customer Region}] ) The following screenshot shows the results of the example. xlsx sample data source and create a new dataset. Example answer is 3. With Amazon QuickSight, you can develop easy-to-understand insights from data while allowing you to connect your data from the Cloud and combine data from various sources. of unique course offerings DESC; Share. The operand must be unaggregated. mateoleon210 March 20, 2023, 12:45pm. To study this, first create these two tables. The expression to return if its if argument is evaluated as true. Hi @Ummehaani - Here is an alt. 0. Previously, the dataset management experience was a popup dialog modal with limited space, and all functionality was. Supported levels are PRE_FILTER and PRE_AGG . The countOver function calculates the count of a dimension or measure partitioned by a list of dimensions. percentileOver. I want to filter this column of distinct count to anything more than 1. It might even be as simple as minOver (Ans_Count, [ID], PRE_AGG) and using SUM aggregation on top of it in the visual. Typically the values corresponding to the dimension that will be aggregated (e. Example below would result in 4 column1. percentileDiscOver uses actual values to determine result. AWS QuickSight: Calculate Aggregate Percentage in Table. You need to provide at least one other dimension via aggr()-formula to show where the distinct Id's should be counted. Amazon QuickSight is a fast, cloud-native, serverless, business intelligence service that makes it easy to deliver insights to everyone. I succeed creating the calculated field, but when I tried inserting it into the visualization - I got the next error: " Your calculated field expression contains invalid syntax. In the example, listing Female and Male will mean that unless the user selection is Select all, the user will automatically filter out the rest of. Amazon S3 data sources save the manifest file information. dateDiff takes two dates as arguments. Choose Athena as the data source. When we compare the results with Profit Ratio we created earlier, the numbers are quite different! This is because Profit Ratio calculates the transactional-level ratio first and then finds the average; whereas Profit. Window functions aren't supported for MySQL versions earlier than 8 and MariaDB. Sorting for pivot tables is different; you specify the sort order by using. The following tips can help make it easier for Amazon QuickSight to automatically map fields between datasets, for example if you are creating a filter action across datasets: Matching field names – Field names must match exactly. This is my data (simplified): Date User First Purchase Type Amount Q. In a bar chart how can I get the right relative value so that its based on the sum of the rows and not the count distinct? Thank you. 0 Remove duplicate values in googlesheet. You can click or tap on the field and choose Sort from the context menu. Connect QuickSight to many different sources. There are two varieties of the percentileOver calculation available in QuickSight: percentileContOver uses linear interpolation to determine result. I need help to for using countif in QuickSight. If someone can help. Now, I’d like to calculate a count distinct in a visual disregarding any dimension of the visual I tried distinctCountOver({id},) and it doesn’t works. . 102 on 1/31/2020 means that in the past 30 days there is 102 distinct user that active (from 1/2/2020 to 1/30/2020)For Computation type, choose Period to date, and then choose Select. I use a simple count distinct : distinct_count({id}) and it’s OK. Hi, I have a parameter to switch between two field - sample size & z-score. (Optional) Add more visuals to the analysis. The only way I have found is to add a column and set the aggregate to count, which puts a “1” in the cell for every row, and then I can turn on totals to see the count. The brackets are required. The windowCount function calculates the count of the aggregated measure or dimension in a custom window that is partitioned and sorted by specified attributes. Choose Save. GROUP BY a. e. Did you try using function distinct count over? You can follow the same calculation logic, instead of using sum, can use distinct count. Use a data source to access an external data store. For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight. This is called a LAC-A function. For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight. 6. QuickSight begins the week on Sundays. Edit format of the date field. As far as for the workaround you might have to perform such computation in data-prep using joins. jjc March 18, 2022, 3:27pm 1. g. 1 Solution. g. You can either change the aggregation in the field wells, or wrap your. The total stations below are static numbers which can not be grouped by months. Get the distinct customers with their salary, add a dummy column called “flag”. Arguments. They also include minOver and maxOver, which can calculate minimum and maximum over partitions. QuickSight has carefully designed concepts and features that enable analysis builders, such as QuickSight authors, to design content-rich, interactive, and dynamic dashboards to share with dashboard viewers. I followed the above process and created multiple datasets. The following example sums Sales only if state_nm contains New. Amazon QuickSight is a fully managed, serverless business intelligence service for the Amazon Web Services Cloud that makes it easy to extend data and insights to every user in your organization. Within the “QuickSight access to AWS services” section, click “Manage”. Add a comment | 0 Try -100 instead of -52. So is there any way how do I remove the count column? PFA the view of my analysis. of unique course offerings FROM offering GROUP BY offlocation ORDER BY COUNT (distinct offbegindate,crscode) as no. The windowCount function calculates the count of the aggregated measure or dimension in a custom window that is partitioned and sorted by specified attributes. My dataset has over 10 million rows, which is data for 3 months. This Quicksight *difference functions seems to break when in the Columns you have expandable granularities. I hope I understood your question and apologise if I haven't understood correctly. Based on a conditional statement, the sumIf function adds the set of numbers in the specified measure, grouped by the chosen dimension or dimensions. The total stations below are static numbers which can not be grouped by months. Especially when data is generated through joining across multiple tables, the denormalization of datasets can add a lot of complications to make accurate calculations challenging. I am trying create a calculated field which counts a distinct count of IDs. period ToDateCount (fare_amount, pickUpDatetime, WEEK, parseDate. Amazon QuickSight connects to your data in the cloud and combines data from many different sources. We do have a road map item to support such functions natively. We're in the process of updating screenshots and procedural text. The count function calculates the number of values in a dimension or measure, grouped by the chosen dimension or dimensions. From the top menu, choose Add data. To find a feature or item, use the Quick search bar. 1. SYNTAX. In a single data dashboard, QuickSight can include AWS data, third. 3; asked Jan 24, 2022 at 9:40. My requirement is that i have to count the distinct phone numbers in January but only the ones that also appeared in the previous month. There are two types of calculated fields: on a data set level and on on analysis level. I have tried to utilize distinct_countIf() and put them in a list. Before we can create a dataset and visualization, we need to grant QuickSight access to the Athena Neptune Connector Lambda function that we created earlier, the Athena query results S3 bucket, and the S3 bucket where the Athena Neptune Connector spills over the results. I want to filter this column of distinct count to anything more than 1. In the example below I added a fictional "CustomerID" field for demonstration. 46, instead of the amount shown (47826. ctine: distinct_countIf ( {row_id}, {country} = ‘New Zealand’) / sumOver (distinct_count ( {row_id})) Hello Tin, Totals and subtotals are blank for table. my user case is based on the {CM_per_truck} or {carrier_per_truck} to identify if the shipment is under Milk-run scope. When you explore large datasets, a common use case is to isolate the count of distinct values for a column using COUNT(DISTINCT column). If someone can help, it will be great, thank you !Hi @ksfx77 if you drag the Date into a visual or table, and create a measure "Measure = DISTINCTCOUNT ( Table[Column] )", you should be able to drag the measure in and get the distinct count for the specific dates. In the example below I added a fictional "CustomerID" field for demonstration. To create a word cloud. status-1. Say you have a line chart with at a daily level, but you want to count the records from. Could you please provide a bit more detail as to what the data. I am trying to make a calculated field in AWS Quicksight for leads that have closed. Navigate to QuickSight, Dashboards, and select <stack-name>-EvaluationFormAnalytics_v1. Add a numeric filter to a dataset in Amazon QuickSight. I’m trying count distinct ID’s but combining different companies into categories and using it as a filter. With the addition of Customer Segment, the total amount billed for each is summed for the. Especially when data is generated through joining across multiple tables, the denormalization of datasets can add a lot of complications to make accurate calculations challenging. create a new visual and select the KPI visual type. calculations. The count of queries run depends on the cardinality of the dimension used in the pivot table. Using distinctCountOver in the dimension field. Hi, I am looking for help in calculating correct attainment % in cell F8 in the attached screenshot. The fields in the table calculation are in the field wells of the visual. 2023, 10:21am 1. In fact, I did not formulate correctly my question: I want some calculated values from my data for this month and this week (reference date = now). QuickSight Actions provide advanced filtering capabilities through single point-and-click actions on dashboards. Currently, my sumover calc looks something like this and attainment shows 180% but it should be 160% since values for c & d are same. Quicksight: Aggregation Over Last. This column (Users) has “count disctinct” setting turned on. You can specify either ascending ( ASC) or descending ( DESC ) sort order. distinct_countIf({row_id}, {country} = ‘New Zealand’) / sumOver(distinct_count({row_id})) Hello Tin, Totals and subtotals are blank for table calculations on metrics aggregated by distinct count. You can replace datasets, customize labels, and format dimensions that are aggregated with count and count distinct. person 1 - symptom A, B person 2 - symptom B, C, D person 3 - no symptoms person 4 - symptom A etc. Preview rows – A preview of the sampled rows appear at bottom right when the join configuration editor isn't in use. You can hover over the label for the field you want to sort by, and choose the sort icon. Dimensions are text or date fields that can be items, like products, or attributes that are related to measures. 1,529 8 8 silver badges 19 19 bronze badges. Viewed 309 times Part of AWS Collective. Share. For example, suppose that there is one filter of state = WA and another filter of sales >= 500 . For example, when you hover over a single bar on a bar chart, information about that specific bar displays in a tooltip. g. An aggregated measure or dimension that you want to see the running count for. You can also create:Today’s announcement expands QuickSight Q, a natural language querying capability, to support forecast and “why” questions and automate data preparation, making it easier and faster to start asking questions in natural language. In response to maxgro. ABC Customer/12345/100. You can use sample data to create either a simple or a more advanced analysis. Aggregation -> No Aggregation. whenever I tried adding at the moment that I'm configuring the data source, it'd fail. Then I created a second calculated field "Total Register Count" with the following formula. Prior to QuickSight he was the lead product manager for Inforiver, responsible for building a enterprise BI product from ground up. e. I am trying to find a way to find unique combinations of up to 4 columns on Amazon Quicksight, for example, the table below should result in 5 unique. PDF RSS. Each of these functions returns values grouped by the chosen dimension or dimensions. For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight. From the Amazon QuickSight start page, choose Analyses, and then choose the analysis you want to customize. This computes the number of orders per customer, before the display-level aggregation of the visual. Using text boxes. The following example shows the minimum Billed Amount over Customer Region. (Optional) The time period across which you're computing the computation. 1 Answer. 1. In the example above, I would expect the. E. We have not heard back from you regarding your question. The above still does not work because percentOfTotal does not support distinct_count() aggregation yet. Athena makes all of this very easy. distinct count from Feb 2022 to Jan 2023. The problem comes when calculating the total number of messages, distinct_count(messageId), because in each row of the table, it’s filtered by violation so in every row the divisor is the same as the dividend so the percentage is always 100%. Tatyana_Yakushev April 23, 2022,. The account name uniquely identifies your account in QuickSight. , year-to-date) period functions which allow you to easily introduce these calculations in business reporting, trend analysis and time series. Question & Answer. In addition to launching URLs, you can also trigger other URIs like mailto: to trigger an email compose window to open as an action result. Take care that multiple filters applied to. Although the steps are slightly less simple, you can also calculate the sum of distinct values on Tableau using the function given below: SUM({FIXED [ProductID],[DueDate]: AVG([OrderQty])}) SUM () – this function will sum the result of the expression. Accepted Answer. Count ( {$<CPRODUS= {'A19'}>} distinct CCLIENT) OR // value changes based on selections. We will update the data to the current date so your calculations are realistic. Here is your base table named Table. Sorted by: 5. Based on a conditional statement, the avgIf function averages the set of numbers in the specified measure, grouped by the chosen dimension or dimensions. chrigu. However there are multiple closed statuses in use. So by using this as the input to the datediff I was able to solve. This construction is not currently supported in SQL Server. What I do is adding a KPI visual with the distinct count of userID applying the same filters. We are hoping to add this soon. I figured out how to do it via browsing more posts using the AGGR function: sum (aggr (sum (DISTINCT [Sales]),. When I collapse the region and the stations. Follow. Under QuickSight access to AWS services, choose Add or remove. Amazon QuickSight can automatically map fields between datasets in the same analysis. Amazon QuickSight recently launched a new. I have this: Customer/ID/Revenue ABC Customer/12345/100. Amazon QuickSight is a scalable, embeddable, ML-powered BI Service built for the cloud. You will receive a popup box asking if you want to filter all visuals with the control. Correct the syntax and try again. I want to count distinct using claim_id field, but the condition is i needto count the latest claim_id date. The total stations below are static numbers which can not be grouped by months. Data blocks parameter—if you have over 10GB of data, start with the default compression algorithm and test other compression algorithms. Share. In contrast, Salesforce and database data sources save connection information like credentials. distinct_countIf({row_id}, {country} = ‘New Zealand’) / sumOver(distinct_count({row_id})) Hello Tin, Totals and subtotals are blank for table calculations on metrics aggregated by distinct count. It could (and should, in my opinion) be implemented in a future version. eg: we have: name id karthik 1 harsha. g. New Amazon QuickSight releases appear in different AWS Regions over a period of time, beginning with the first Region on the initial release date. The expression must have the same data type as the other then arguments and the else argument. the 3 / 5 should refer to the total sum of the rows. In the new insight that you created, add the time dimenstion and value dimension fields that you want to compare. These perform the same type of aggregation, based on a condition. i basically want to not sum duplicate values twice. When I take the average value of the Age column then Employee 1 and 4’s ages are twice in data, giving me an average age of 41. Hi @ctine. Dear Community, I want a view of a pivot table but I don’t want to see the count column. You could create a calculated field and use the sumOver function . I am trying to use distinct_countif and was wondering if the. You can connect QuickSight to your Athena databases and tables in the region and start visualizing your data in a matter of seconds. For example, when you are looking at the number of unique. The first date in the comparison. Valid granularities include YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, and. From the top menu, choose Add data. To change the aggregation, open the field’s context (right-click) menu, and then choose a different aggregation. We are using AWS Quicksight to create dashboards to view the data. but it giving me unexpected result, not sure if i am missing something here. Khizar. The following example. Biswajit_1993 June 10, 2022, 10:36am 1. You can approach this in the analysis without data prep/ETL. It is now possible in Amazon QuickSight. In the menu the opens, click "use parameter". Amazon QuickSight is a fast, cloud-native, serverless, business intelligence service that makes it easy to deliver insights to everyone. aws. SaaS Business Intelligence refers to the use of cloud-based software solutions to perform data analysis, generate reports, charts, and visualizations, and gain actionable insights. QuickSight account name. I’ve tried so many different things, but I still keep getting 8771. Or, if you want to aggregate via QuickSight, you would use sumOver (sum (Ans_Count), [ID]). Add a comment. I have data that looks like this: Employee Employment Age 1 a 35 1 b 35 2 a 40 3 a 35 4 a 51 4 b 51 I want to calculate the average age of the individual employees. cant do distinct sum if in quicksight. The count of unique ID's where Color is RED is 2, being WD14 and DB09. Question & Answer. I. The account name uniquely identifies your account in QuickSight. of unique course offerings DESC; Share. If you want to count all the data points in a given partition I would use countOver instead. Amazon QuickSight at a glance. But if anyone knows a way to implement. The number of months of data the Athena views will contain. Then when you drag and drop it into the visual choose a Count Distinct, or in your calculation wrap the whole thing with distinctCount(). 2 karthik 3 Vikram 4 karthik 5 I want the syntax in QuickSight for counting the number of records karthik has in the above. windowCount would allow you to specify a ‘lookback’ window of how many data points prior (or after) you want to count. SYNTAX. Use the following procedure to join tables to use in a dataset. I would like to create a donut chart that shows how many companies have 0-10 employees, 11-50 employees, 51- 100 employees,. How would we sum up all distinct count values of an ID over the previous 4 weeks (not including the current week) divided by 4 (number of weeks)? We’re trying to get an average distinct_count of ID’s over. Hi @Biswajit_1993, What you are trying to accomplish can be achieved using visual type pivot table. That’s to say it aggregates it based on the group. In PowerBI, add a new table and paste the following code. The count of unique ID's where Color is RED is 2, being WD14 and DB09. Amihai. Refer to your QuickSight invitation email or contact your QuickSight administrator if you are unsure of your account name. amazon. For example, if three cities share the same ranking, the fourth city is ranked as fourth. On the analysis page, choose the pivot table visual that you want to edit. I tried Notion – The all-in-one workspace for your notes, tasks, wikis, and databases. Trailing 12 month distinct counts for each month in the dataset. QuickSight account name. mansiish March 10, 2023, 10:47pm 1. AWS Regions provide multiple physically separated and isolated. Amazon QuickSight now offers enhanced dashboard interactivity capabilities through QuickSight Actions. A funnel chart is basically used to show the flow through any business process, most commonly in sales. If you want to see the Pass/Fails you can create a new Calculated Field with the score logic in an ifelse, something like this: ifelse ( {score}>=98%, "Pass", "Fails") Correct. E. So I went through and added the calculated field on the area where I can. 08) please if anyone has an. Partition functions. Creator II. included in “month” value). In the example above, I would. Amazon QuickSight at a glance. Discoverable visual menu. It can include AWS data, third-party. My “best” guess so far is: distinctCountOver({Id}, [${1stOfThisMonth}, ${SundayOfThisWeek}]) where 1stOfThisMonth and SundayOfThisWeek are parameters (rolling date from 1st of the. Regards. Then the dataset or analysis only contains records that meet both of those criteria. To collapse a group, choose the collapse icon near the name of the field. Ahmed_She March 30, 2023, 3:22pm 1. From the documentation: For LAC-W functions, the visual aggregation defaults to MIN to eliminate duplicates. Current workaround is to make changes in. PDF RSS. when an ID has one occurence in May and one in June, it should count it once in May, but not in June - however, as the sum of distinctcounts per months is bigger than the “total. Amazon QuickSight Community Distinctcountover not taking calculative field as partition by field. This post presents a simple approach to aggregating AWS WAF logs into a central data lake repository, which lets teams better analyze and understand their organization’s security posture. Tom McMeekin is an Enterprise Solutions Architect with a career in technology spanning over 20 years. After updating, save the dataset. However, my dataset contains duplicate rows which are created by addition of group and division fields ( many-to-many relationship with owner_id field ). 3/ Added a calculated field on UI for YTD using runningSum() on 2/ ; ordered by date , partitioned over teams. (Optional) The time period across which you're computing the computation. It is computing on the row level. RETURN. 0 Let the readers to be able to save sets of filters as bookmarks. There are two varieties of the percentileOver calculation available in QuickSight: percentileContOver uses linear interpolation to determine result. I am trying to count how many tasks where resolved in each week no matter when they where created, Quicksight only counts the ones that where created that week. The thing you can use to your advantage is that the COUNT function (DISTINCT or otherwise) does not count NULLs, so you just have to put a null in where it is not the type you wish to count: count (DISTINCT If (service_state='CRIT', alias, null ())) That should do the trick. Then make a KPI visual with ID as the Value and aggregation set to "Count distinct" and add a Filter for your calculated. Current workaround is to make changes in the data prep or. Usually, you use custom window functions on a time series, where your visual shows a metric and a date field. Many AWS customers use multiple AWS accounts and Regions across different departments and applications within the same company. How. The countOver function calculates the count of a dimension or measure partitioned by a list of dimensions. If I do something like:distinct_count({transaction_id)) / distinct_count({customer_id}) and then plot it on a chart by week, the denominator becomes the count of customers who had a transaction. To get this use:Publishing Your Dashboard. By using parameters, you can create an easier way for a dashboard user to interact with dashboard features in a less technical way. how-to, calculations. Then when you drag and drop it into the visual choose a Count Distinct, or in your calculation wrap the whole thing with distinctCount(). These fields are indicated in Mode with. In the Value field well, choose a field drop-down menu, choose Show on: Left Y-axis, and then choose Right Y-axis. pass-failed-some - Count of students in the department where the current state is pass and there is at least one failed test; To do this I've created a dataset that contains Student joined to Test. Hi exeprts, I have a fairly complicated formula I’m trying to accomplish in QuickSight. Amazon QuickSight recently added native support for comparative (e. My data contains FName, LName, MName, Gender, Card ID, Health ID, Active Flag and there may be Null in any column for each row i am trying to calculate distinct count (FName+Card ID+Health ID) and distinct count (FName+Card ID+Health ID+Where Gender=M) FNAME LNAME MNAME Gender Card ID Health ID Ac. QuickSight account name. Make sure the dataset you want to use is selected in the drop-down in the dataset section (1) and click the add button in the top left corner (2) Click Add visual and create your visual as you would normally. If Ticket_No is null no need to count employee. If you disable one of these, only one filter applies. It seems that distinct count is double counting. Amazon QuickSight Community How to remove count column from a pivot table chart. distinct_count 関数は、ディメンションまたはメジャーの個別の値の個数を計算し、選択した 1 つ以上のディメンションに基づいてグループ化して返します。. The date dimension over which you're computer PeriodOverTime calculations. countIf ( Revenue, # Conditions CalendarDay >= $. 06-30-21 is Wednesday. Additionally, customers can now create and share paginated reports alongside interactive dashboards, quickly. todd. Related questions. 1M. of unique course offerings FROM offering GROUP BY offlocation ORDER BY COUNT (distinct offbegindate,crscode) as no. You can either change the aggregation in the field wells, or wrap your calculation in a. QuickSight account name. Amazon QuickSight has launched a new user interface for dataset management. Resilience in Amazon QuickSight. Virginia and Ohio), US. (Optional) The time period across which you're computing the computation. Or you can create a dual-axis line chart using the Format Visual pane: On the menu in the upper-right corner of the line chart, choose the Format visual icon. hafizsultan February 10, 2020, 9:25pm 2. But it would be great to have the feature of adding calculated field from the analysis inside of the partition by of distinctcountover like how it is possible in sumover and count over. Hi, I’m fighting on a (I thought so) simple calculation. Question & Answer. I agree with the above. Abs(expression) – Returns the absolute value of a given expression. Fully managed cloud-scale AWS BI tool. Amazon QuickSight Community Count Distinct with latest event. I would like to count the number of days that users have logged in over a period of time and then group the results by the number of days logged in so I can create a power user curve. cant do distinct sum if in quicksight.