Hi first of all, your videos are great. Many thanks for sharing. I have a question about goals. I've already have a two tables in the script. Sales and Calendar Sales. When I add Goals Table with MonthYear I've a problem with Circular Reference. "MonthYear". Do you have any sugestion to fix it?
I think it's very comum people use crosstable MonthYear to add MonthYear goals. I'd like to know if you have any video that show us how to make an expression to check this MonthYear per Workday. Example: I have 260,000 as a goal for Jan/23 and I have 26 working days for this month. My sales from 01/JAN/23 TO 15/JAN/23 was 130,000 - (12 working days) So... I've already made 50% of my JAN/23 goal. And for the first 15 days (12 working days) I'm 108,3% Many thanks again.
Good quality video
Very good, thanks
Hi first of all, your videos are great. Many thanks for sharing.
I have a question about goals. I've already have a two tables in the script. Sales and Calendar Sales.
When I add Goals Table with MonthYear I've a problem with Circular Reference. "MonthYear". Do you have any sugestion to fix it?
Question is if the second table, Monty year are the same, how to differentiate target and sales, as this is often the case in reality? Thanks!
You can add 'Sales' as Flag, 'Target' as Flag .... If you give me exact dummy data, I can help you further.
I think it's very comum people use crosstable MonthYear to add MonthYear goals. I'd like to know if you have any video that show us how to make an expression to check this MonthYear per Workday.
Example: I have 260,000 as a goal for Jan/23 and I have 26 working days for this month.
My sales from 01/JAN/23 TO 15/JAN/23 was 130,000 - (12 working days)
So... I've already made 50% of my JAN/23 goal.
And for the first 15 days (12 working days) I'm 108,3%
Many thanks again.