Forum Discussion
Calculated Measure within a rotating tile
Hi, I have a custome tile on a report that rotates. I have 2 datasets that feed into the tile.
Dataset 1 is a complete list of "closures" all I do here is drag a field into the Measures and do a count of that field.
Dataset 2 is a table of targets by date. I have created a relationship betweeb the 2 datasets on date. The measure used from here is sumoftarget. This works perfectly, however I want to be able to calculate percentage of countoffield1/sumoftargets, any ideas how I go about this?
5 Replies
I have for example the following in dataset one
Date Closed By
01/01/18 Mr smith
01/01/18 Mr Jones
02/01/18 Miss Bunny
03/01/18 Mr Green
02/01/18 Mr Brown
In dataset 2 I have
Date Target
01/01/18 4
02/01/18 4
03/01/18 1
In the measure section of my tile I would have
Count of ClosedBy = 5
Sum of Target = 9
I want to be able to create a third that gives me 5/9 as percentage
There is also a chart on the report that shows count of closed by as a bar and target as a line by day. Therefore when one of the bars is chosen the rotating tile auto changes to show figures just for that day.
Cheers
I dont know how to add countofclosedby / sumoftarget as a new measure
