Forum Discussion
Group By
Wondered if anyone could put me on the right track.
I have a table with 5 columns
ID, Present, Authorised, UnAuthorised, Date
- I want to aggregate the table by the ID between Dates
- Then calculate the % of Present/(Authorised+UnAuthorised+Present)
- Then check to see how many % are below 90%
This seems a simple question but I am getting confused with how to combine GROUPBY , SUMMERIZE and can this be done dynamically when a date slicer is changed ?
3 Replies
hello Power-User can you please share a sample of your data without revealing sensitive data?
I have a larger data set but cant upload the pbx file with it in.
Primary Key Present Authorised Absence UnAuthorised Mark date Person 1 0 0 0 9/5/2022 Person 1 0 0 0 9/6/2022 Person 1 0 0 0 9/7/2022 Person 1 1 0 0 9/8/2022 Person 1 1 0 0 9/9/2022 Person 1 1 0 0 9/12/2022 Person 1 1 0 0 9/13/2022 Person 1 1 0 0 9/14/2022 Person 1 1 0 0 9/15/2022 Person 1 1 0 0 9/16/2022 Person 1 1 0 0 9/20/2022 Person 1 1 0 0 9/21/2022 Person 1 1 0 0 9/22/2022 Person 1 1 0 0 9/23/2022 Person 1 1 0 0 9/26/2022 Person 1 1 0 0 9/27/2022 Person 1 0 0 0 9/28/2022 Person 1 1 0 0 9/29/2022 Person 1 1 0 0 9/30/2022 Person 1 1 0 0 10/3/2022 Person 1 1 0 0 10/4/2022 Person 1 1 0 0 10/5/2022 Person 1 1 0 0 10/6/2022 Person 1 1 0 0 10/7/2022 Person 1 1 0 0 10/10/2022 Person 1 1 0 0 10/11/2022
pk thank you can you please let me know if you ened a new calculated table or just measures?
