Toggle for Columns on a Line and clustered column chart
I have the following data sets:
I am looking for a way to display the count of tasks from Task Details as lines graphed over time and display the Date from the System Dates as a vertical bar for each occurance. I would like to be able to filter on Task Name and toggle the System Dates on and off.
As you can see there is a many to many relationship between system from Task Details and System Dates.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacadsqlbiMy Video Series Appreciate your Kudos.