Missing months in the bar chart when there's no data for them about cubesviewer HOT 1 OPEN

Yes. This has been bothering me too for too long too.

When using Cubes with an explicit date dimension table (as opposed of extracting year/month/day from a single DATETIME column), you should be able to tell cubes to do a right join using:

To join a date dimension table so that every date will be present in the output reports, regardless whether there are any facts or not for given date dimension member:

"joins" = [
    {
        "master": "fact_contracts.contract_date_id",
        "detail": "dim_date.id",
        "method": "detail"
     }
]

Read the documentation because it contains some extra information: https://cubes.readthedocs.io/en/latest/backends/sql.html

Now, I'll try to implement this at CubesViewer level too because I'm interested in supporting this even when no table joins are involved (like when using DATETIME columns) or for supporting CSV data directly in CubesViewer. But note that progress in CubesViewer is slow. I'm undergoing a heavy refactor and I have no target date for the next version.

from cubesviewer.