Maybe you can try the technique of using:
THEN [xyz value]
I'm sorry it has taken me this long to reply. I just saw this.
I have never seen this calculation, so I don't really understand it. Would you please expand on it?
Thank you so much for your reply.
I'll take a stab at it:
FIRST() calculates distance to the first row in a partition,
so if it is equal to zero then you should be able to use it to just show the date above the first request ID.
Also described here:
My apologies, I didn't explain in depth.
Please see if the below and the the attached leads you closer to the solution.
Using FIRST() requires all other fields in calculation to be aggregate.
Here, you can use ATTR() as the aggregation. That should just return the date.
For the purposes of formatting, I just converted the date into a string, and just showed
it on the first instance, and left all the others as a blankspace.
THEN STR(ATTR(DATEPART('day',[Request Date])))
ELSE " "
requestid.twbx 9.9 KB
OMGSH! That was perfect!
Thank you so very much!!
If you have the chance, would you please explain to me the logic behind this (I know you did already, but I'm rather slow when it comes to computing logical fields.) If you can't, that's ok too.
Thanks a lot! I really appreciate your help.
1 of 1 people found this helpful
Glad it worked for you.
Not sure how well I can explain it.
Basically, the calculation says that if the RequestID is the first of the group (FIRST()=0)
then show just the number of the day of the RequestDate as a string.
Since FIRST() is an aggregation, all the other fields need to be aggregates.
I just used ATTR() but probably other aggregates could work too, like MIN.
Here is more discussion on ATTR()
You explained it beautifully!
Thanks a lot.
Have a great day!
What if you don't have data for some of the weeks/days? It only displays the week if you have a record for that day. How can you display a full calendar to show what the schedule actually looks like?
Great solution to my calendar problem with multiple events, thanks!
One question I have is around the dimension colors - the days in my calendar take on the same color as the 1st event - anyway around this?
Hmm, not sure.
Typically could be done with a dual axis, but don't think that will work with the particular setup above.
to see if others had achieved it, but didn't immediately see a solution.
Will work on it.
Sorry for the long-after-the-fact reply, you've likely already seen the other answers here
but just for the sake of completeness, one method would be to have a second sheet
with all the possible dates, and join that with the data sheet.
182339cal1.twbx 14.2 KB
I got something sort of working, space formatting is awry, but maybe this can be a first step for you.
I converted the individual entries (in this case ID) to a Measure, and then turned off aggregation.
I then put Measure Values on the Text shelf, and a combination of Measure Name + Group on the Color Shelf.
Had to individually change the day number colors to black.
182339cal2.twbx 22.8 KB
I'm trying to replicate the scenario with my data but couldn't separate the color between the date and other value. Could you please look at my workbook attached and let me know where I have missed.
Calendar.twbx 56.0 KB