-
1. Re: How do I count the number of records within different time periods?
Deepak RaiJun 20, 2018 12:58 PM (in response to Claire Lofgren)
Hi Claire,
Here It Is:
These are The Calcs:
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to close Thread
-
Complex with Null.twbx 13.8 KB
-
-
2. Re: How do I count the number of records within different time periods?
Claire Lofgren Jun 20, 2018 1:14 PM (in response to Deepak Rai)Thanks Deepak,
This seems like the right track, but is there any way to get those counts (the two right rows) as details per column? as in, hover over a cell and it will tell you how many are in the set?
-
3. Re: How do I count the number of records within different time periods?
Deepak RaiJun 20, 2018 1:25 PM (in response to Claire Lofgren)
You Can Add Those Into Tool Tip. You can Just Drag Them into Tool tip. Can you Please Take a sec to Close Thread by Marking my Reply as Helpful and CORRECT. The CORRECt Button is under my Reply in this main Thread, Not in email.
Thanks
Deepak
-
4. Re: How do I count the number of records within different time periods?
Deepak RaiJun 20, 2018 1:29 PM (in response to Claire Lofgren)
-
Complex with Null.twbx 18.8 KB
-
-
5. Re: How do I count the number of records within different time periods?
Claire Lofgren Jun 20, 2018 1:30 PM (in response to Deepak Rai)I guess I wasn't clear, sorry!
I do not want a universal tooltip that lists all of the different time periods. I will end up having about 10 time periods and don't want to clog the tooltip that way.
I'm looking for something like a "number of record" field that changes as you scroll across the columns. Basically looking at the denominator of each calculated field
-
6. Re: How do I count the number of records within different time periods?
Deepak RaiJun 20, 2018 1:34 PM (in response to Claire Lofgren)
Pl see attached and you can modify accordingly. Your Question was a Good Question, Though, Little Complex
Thanks
Deepak
-
Complex with Null.twbx 18.9 KB
-
-
8. Re: How do I count the number of records within different time periods?
Deepak RaiJun 20, 2018 1:46 PM (in response to Claire Lofgren)
I am Sorry, I Don't Think You Can Do That Way...I have Not Come across That Thing...But, You can Create a Separate thread for that after Closing It so that Someone can Show you how to get that.
Thanks
Deepak
-
9. Re: How do I count the number of records within different time periods?
Claire Lofgren Jun 20, 2018 1:51 PM (in response to Deepak Rai)Ok, I’ll leave this open though. Thank you for your efforts!
Best,
Claire
-
10. Re: How do I count the number of records within different time periods?
Deepak RaiJun 20, 2018 1:56 PM (in response to Claire Lofgren)
Well....That may not be Helpful, as your Initial Question was Answered So People Might Not Go Down To the End To answer the Supplement, So It is always better to Create a New Thread, you can attach the Packaged Workbook Which I attached and with New Header, That way you would get Help faster.
Thanks
Deepak