Forum Discussion
Solved
Data changes after click row
I'm hoping someone much smarter than I am can help. I have 2 tables shown on a report. Clicking on the row of 1 table makes that data in the second table disappear despite the data being tied to the ...
Are the data from two visuals coming from the same fact_sheet? If not, better check the relationship diagram. I'm making a bold guess: could you use one dim_date table and link it to [ActiveDateTime] and [CreatedDate]? If that's the case, the interaction will cause 2nd table to disappear.
Ok I think that solved that problem but now i've ran into another problem.
Basic Table Layout
PropertyTable
| PropertyId | Customer Name |
| 1 | Joe smith |
| 2 | David Small |
ActivityTable
ActivityId | PropertyId | Details | Date |
| 1 | 1 | talked to customer | 08/31/2022
|
| 2 | 2 | Met Inspector | 9/1/2022 |
| 3 | 1 | Collected Check | 9/1/2022 |
So in my report I have two tables show in the pictures above.
In the top table I have a new column with the following formula
Last Activity = DATEDIFF(TODAY(), DATEVALUE(max(Activity[ActivityDateTime],Activity[PropertyId])), DAY)* -1
Which returns how many days have passed since contact with the customer has been made.
The issue is in the second table below, only the last activity for that customer will now show.
Any ideas how to fix this?
nvm it was being summed. Thanks for the help.