Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
When i am creating data modelling i got difficulties to link 3 table with composite key and i think my linking is not proper.
can you please check and validate.
When i am creating reports month is not coming.
PFA
Any help?
Some of the dates are pure dates and others a datetimes.
Converts all date to pure dates with statements like this :
date(floor( [Resolve Date] ) as [SSR Resolve Date],
Hi bill,
I want to know that why months are not coming for my "Service desk call Abandonment Rate" chart.
Thanks.
it seems there is no connection - you are using timestamps as your date fields...better clean/transform them as Bill suggested. So use e.g. date(floor(... to get matching dates
Hi Vijay,
As per my analysis, you don't have the data related to the STATUS value your checking for. Can you please share the xls file , lets have check
Hi Daniel,
I already use date(floor(... ) function.
Can you please explain me how can i get proper linking with composite key.
Thanks
just as example: in your table Sample Dump File:
You use [Resolve Date] to link to the calendar...but you dont use any Date(floor( here
Hi Daniel,
I did the correct as you said but still i dint get months as dimension.
Thanks
Could you upload your latest version again.
If the keys are ok, maybe you need to use MonthStart() instead of Month...but need to check