is a Measure = / Īll of these Measures are filtered by multiple filtered visualizations and page level filters from many different tables and have a relationships created using an index number between the tables. is a Measure which adds together a column from a table and divides by the distinct count of records in that table is a Measure which adds together 5 other Measures from 5 different tables Desired Result: Category | Total Cost | Hours | Cost per Hour | % of Cost per Hour I would like this % of GT of Cost per Hour to use the total sum of the Cost per Hour column. However, if i simply add to the treechart again and use the "quick clac" functionality on the field it would return 823.7% for the first record in the above table as (100/12.1495) = 8.2307. I have a Matrix visualization that provides Cost by Hour using measures.Ĭategory | Total Cost | Hours | Cost per Hourįor my purposes I would also like to create a % of Grand Total of Cost per hour to add to a treechart visualization. Hi all, this seems so easy in my head but I haven't been able to get it for the last few hours.
0 kommentar(er)
