Forum Discussion

Jonvoge's avatar
Jonvoge
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Hi Gokul_G16

 

One issue in your report seems to be the missing dates.

I am guessing that you are using a Date column from your Fact Table, and not a separate Date Table?

I would highly advice you to use a Date Table, in order to fill out the blank dates in your table.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

Gokul_G16's avatar
Gokul_G16
Icon for Resolver I rankResolver I
2 years ago

Hi Jonvoge ,

Thanks for responce,

Yes, aggreed it the date are missing. it seems our end weekends are excluded.

I have used measure seprate dim_date master only. Is there any possible to make the based on Fact table rows available to be calulated the variance Previous day - Today Variance Count.

Thanks,
Gokul

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User
      2 years ago

      Gokul_G16 ,

      Can you try Visual Level Calculation?