Forum Discussion

carlm1975's avatar
carlm1975
Frequent Visitor
8 years ago

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 cou...
carlm1975's avatar
carlm1975
Frequent Visitor
8 years ago

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

carlm1975's avatar
carlm1975
Frequent Visitor
8 years ago

I dont know how to add countofclosedby / sumoftarget as a new measure