Forum Discussion
Numbers have changed in Visual
Hi, I have just found out that a new team has been created and these aren't being counted in the stats. I think I know what I need to do now - thanks anyway!
Hi,
Considering what you're trying to do, I think the better way to do it, is to just put in the id column into the visual. Turn it to a count and then filter the visual itself to only records within a year. There's no real reason to use Total YTD from what I can see.
If you really want to use that function, then I'd suggest to double check that your calendar table is marked as a Date Table. (Go to Modelling view, click on Calendar table and then mark as date table).
The Time Intelligence functions rely on using Date Tables - if you don't use a marked Date table, then MS Docs say that the results might not be correct.
Ensure that your relationship between the created on field and the calendar table is correct after you've done the previous steps.
Generally though, it'd be much simpler to use the former method I said, as it looks like an unnecessary measure.
Hope that helps.
Thanks for the advice, that is something I will definitely consider doing.