Forum Discussion
Line-up Data Category
Hello, I have three table visuals and would like to display the same sub-category under each main category whether the value is present or not. For example, under Race main cateogry, I do ...
hi Jianbo,
The data set behind each table is from different source, format and granular level (three different table in my data model). I have to perform many transformations in the back-end to get the data in some what uniform format. In addtion, the filtering value are also different for each table because of the nature of when/what data is avaialbe to us from different agency/institution. Ideally, I want to build one table with all the categories and KPIs. So I built the derived table below and join to my three tables (US Censor, Cancer Registry and Clinical Accrual) by CategorySorting value. It seems to work I have to validate the numbers. I will post for sure if my attempt is working. Thank you so much for your response.