Forum Discussion
How to create missing rows
Hi moei
So to achieve this you can create a dimension table for your dates and categories, create a relationship with your current table and use columns from dimensions table in the visuals, and add +0 to your Measure so it looks something like.
Count Rows = COUNTROWS( table ) +0Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Hi Mariusz,
Sure, I will try to explain it in another way.
Below is a screenshot of what I have before I do the running totals.
The first date "28.september" only has 2 rows because no other categories of files were created that day.
These are alle my categories.
I need every date to have all categories represented. So if no files in the other categories are created the 28.september then they should be represented with a row and a value of 0.
Best Regards,
Morten
Hi moei
So to achieve this you can create a dimension table for your dates and categories, create a relationship with your current table and use columns from dimensions table in the visuals, and add +0 to your Measure so it looks something like.
Count Rows = COUNTROWS( table ) +0
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Do you mean a dimensiontable that contains date and catagories or two dimensiontable one for dates and another for the categories?