Forum Discussion
Syndicate_Admin
Administrator
Administratordisplay zeros in line graph
Hello everyone, I have the following case. I need to visualize to zero the records that do not appear in the fact table, of the hours that the employee dedicates to the project. But when I perform ...
lbendlin
Super User
Super UserUsually in such scenarios (when you want to show data that is not there) you need to create a cross join between your dates table and your employees table, and then use measures to calculate if there's a value at the intersection or a zero.