Filter out data and showing them as blank values in table visual
Hi!, is there any trick to filter data in a table visual based on a column value (in this case Confidentialcode), and the rest of data that doesn't contain the expected value show the rows as blank instead of not showing them in the visual. For this example I want to show columns, ID, alias, color and age only if the Confidentialcode is blank, if is not blank I want to show only ID in the table visual, and the rest of the columns should display just BLANK (no values) In my case there is this sample data table: ID alias color Age Confidentialcode 1 dog black 2 12 2 cat white 6 13 3 squirrel brown 3 4 rat white 1 5 cat2 black 4 expected result in table visual: ID alias color Age 1 2 3 squirrel brown 3 4 rat white 1 5 cat2 black 4 Thanks in advance for the help!
Week over Week comparison by country
Hi All, I have a weekly sales measure and a Week on Week measure that calculates the change of sales over week under the same table. On a total sales aspect it works fine. When I add the Country it takes sales of week 2 for the specific country and subtracts it from total sales of week 1. So for UK&I it takes week 2 sales 115784 and subtracts from total group sales of week one, 2,501,074. What do I have to change to obtain weekly difference by country? Many thanksFiltering Table Values
Hello All, parry2k smpa01 AlexisOlson I wish to create a Result Table from the Data Table as seen in the attached screenshot. The Result Table must be such that it will show only those values in the three columns which are corresponding to the Maximum of Sum of Order Value. It will be helpful if we can achieve this functionality. ThanksCalculate difference between consecutive rows filtered by SELECT DISTINCT
I need to calculate the difference between values in consecutive rows and display the value in the 2nd of each pair of rows, apparently without the help of an index. Specifically, I created a calculated column, Workdays Since Filed, and now want to subtract the Row 1 Workdays value from the Row 2 value and display the result in Row 2 as a calculated measure. Values in red show how it should work: PERMIT_ID ACTION ACTION DATE FILED DATE WORKDAYS SINCE FILED (calculated) DAYS BETWEEN (calc) (Just to show math, not a real column) FFXREC215FN Submission Deficiencies Issued 11/29/2021 11/12/2021 11 FFXREC215FN New Document Received 12/6/2021 11/12/2021 16 5 16 - 11 FFXREC215FN New Document Received 12/7/2021 11/12/2021 17 1 17 - 16 FFXREC215FN Waiting for Information 12/10/2021 11/12/2021 20 3 20 - 17 Getting the "Days Between" calculation is complicated by the filters on this table that made using an index difficult. The main filter is PERMIT_ID and that could be indexed using dynamic filtering tricks I saw on other posts in this forum, but the filter that really hoses things up is a SELECT DISTINCT that removes duplicate rows from display when multiple new documents are received in the same day. So the user sees this: Behind the scenes, the table actually looks like this: PERMIT_ID ACTION ACTION DATE FILED DATE WORKDAYS SINCE FILED DAYS BETWEEN FFXREC215FN Submission Deficiencies Issued 11/29/2021 11/12/2021 11 FFXREC215FN New Document Received 12/6/2021 11/12/2021 16 5 FFXREC215FN New Document Received 12/6/2021 11/12/2021 16 0 FFXREC215FN New Document Received 12/6/2021 11/12/2021 16 0 FFXREC215FN New Document Received 12/7/2021 11/12/2021 17 1 FFXREC215FN New Document Received 12/7/2021 11/12/2021 17 0 FFXREC215FN New Document Received 12/7/2021 11/12/2021 17 0 FFXREC215FN Waiting for Information 12/10/2021 11/12/2021 20 3 I worked through solutions on about 5 similar posts but didn't find one that fit this issue specifically. Any ideas? Thanks, Allison
