Hello.
Either PP or PQ question.
I extract a DB from an external system and create graphs per day months or years. I do have an issue when at the beginning of the time unit I need to use, there is no data yet and I loose the format I created.
The way I used to get the current month is to get the actual month with a boolean column (if "actual month" = "month of date" then true else false) and filter the graphs with true or false. It works great and it is very easy but at the beginning of the time unit, since no data exists yet, the graph loose the filter and cannot get it until we choose it again manually.
My way is wrong or can I fix it with a bypass ?
Thanks, Bruno.
Hi Bruno,
I suggest you always have some dummy data in your data model that you can use if the current month data is empty. It likely only needs to be one row. You can then modify your IF to return the dummy data if FALSE.
Hope that points you in the right direction.
Mynda
This was my default fix for that. I will try, thanks.
