Hi. I need to create a matrix visual where i can show the category and be able to click the plus sign to drill down to show all of the applications in that category listed. That is easy so far. The challange is that, each application has a start date and start time and end date and end time. These four coulmns can't possibly be aggregated because it would make no sense. Their values should appear only at the very lowest level -- that is at the application level. For instance, a category will have many applications. Therefore, there should be no value under the start/end date/time columns. These values should only appear when I expand the category to list all the applications. At which point each application will have start/end date/time values under those respective columns. To do that, I used hasonevalue to only show the value when there is only one value available--hence, the lowest level. However, using hasonevalue with a very large dataset, 100s of thoushands of records, it slows down the visual enormously. Is there a different/better way to work around this and to achieve the desired result? Thanks.
