Forum Discussion
Visuals & measures in months without data
Hi GolaubT,
I can't reproduce your design just based on your description, so if possible, could you please inform me more detailed information (such as your sample data and your expected output)? Then I will help you more correctly.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello
Event Table - Date of event/Event count/Event suptype
Hours Table - MonthID (Format ex 201903 for March 2019)/Hours
I have a Calendar table connecting to both tables to give date context to the different fields.
I have one measure which is Cumulative Sum of /Event count/. I have another measure which is Cumulative Sum of /Hours/. Both these measure work as expected on a line visual, start at zero in Jan and show the change through to Sep.
I have Hours every month but I dont always have events. The problem is when I use a filter for /Event suptype/ the visuals will show the correct data, however they will only show the months where there is that kind of /Event suptype/. So my visuals dont display my FR improving becuase there are more hours cumulatively and no events but if I throw in another fake event it will still calculate it correctly for the cumuative totals.