Forum Discussion
bgepps
9 years agoFrequent Visitor
Removing status' from average time calc
In my data set, i have the following columns of data that are being pulled in via a database. Job Status Status start date Status end date I have been able to calculate the average time for...
bgepps
9 years agoFrequent Visitor
Hi tringuyenminh92 - would this remove those status' from the other reports i have in my deck, though?
Or would i have to copy the table, and then filter out the status in the second table, with the same time difference formula's mentioned in my original post?
Appreciate your help,
Ben
tringuyenminh92
9 years agoMemorable Member
Hi bgepps,
Yes, this is filtering dataset, reports using this source (this table) will be filtered these data.
Yes, this is filtering dataset, reports using this source (this table) will be filtered these data.
- bgepps9 years agoFrequent Visitor
Hi tringuyenminh92 - so if i follow my suggestion above, it should give me the information i require, and continue updating as the SQL database is populated with data?
If so i will try copying to a new table later and will keep you updated.
Thanks,
Ben
- tringuyenminh929 years agoMemorable Member