Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I show only an earliest value in a selected day..
Ex:
Case | Value | Time | Date | SalesPerson |
1 | ABC | 6:00 AM | 1/1/2019 | Mary |
2 | BCD | 6:30 AM | 1/1/2019 | Mary |
3 | CDE | 8:50 AM | 2/2/2019 | Mary |
4 | EFG | 10:00 AM | 9/15/2019 | John |
5 | HIJ | 12:00 PM | 3/22/2019 | Doug |
6 | KLM | 7:30 AM | 5/5/2019 | Andrew |
7 | NOP | 7:15 AM | 5/5/2019 | Andrew |
I'd like to show/count Case 1 for Mary for date 01/01/2019 cus that's the earliest case (with time stamp) for her that day and not count case 2 or case 3.
Same for Sales Person Andrew
Would like to count only Case # 7 as that was done 07:15 AM
I tried Peek and also Firstvalue
NoConcatenate
Data:
Load Case ,
FirstValue(Value) as Value
Resident Dim Group by Case;
This gives me the answer but in expression it's getting messed up.
Thanks.
Tried, did not work.
Thanks
Try this:
Thank you..
I'll test this tomorrow?
A quick check looks good... I'm having like a complete data model, need to verify across all dashboard.
So far it's good.. thanks a lot.
This expression you gave seem to work only in straight table.
Not working in Bar chart.. maybe cus using RANK?
Can you attach the app?
I'm trying to count earliest case for that day for that particular person.
Rest should also show up... expression you gave only shows 1st case but doesn't show rest of the cases.
Counting all the cases but if there are multiple cases on same day, I would like to count only 1st case for the day, not multiple.
Can you attach your expected result?
Do you mean like this?
Can you also share the issue you are having with bar chart?
No issue with me creating this table in bar chart.
If I clear all selections & use Year filer 2018, Month Oct, I should get 5 counts.
If you look at data I gave you, that person has total count as 6. But since we are doing 1st case for the day, 10/01/2018 at 07:30 AM will be counted, not the second case on that day.
Actual app consists of a lot of data sources. thats why i cannot upload it here
I'm using a calculated dimension for this chart, which says if variance is <=7, term is at On-time, between 8-15 as late etc..
You are counting case on time here,which gives you 3, rather than 6:
I would suggest you to count by Case ID.