Time Series Visualization is limiting the results to 10

[mikkojuola]

Dear community members!

I'm trying to create a Column type of Time Series visualization to show data with weekly grouping and use a filter to change the date range. Something that was easy to accomplish with "classic reports and interactive dashboards"

But I have a problem with the report / visualization only showing maximum of ten columns, not matter how many weeks I'd like to include into my report.

• My Data Source has a filter where "Created > Last 12 months".
• Metric is a distinct count
• Grouping based on simple choice list value on the source table
• Trend by "Started" date.

And here's what I get.

A column trend, but only showing first 10 weeks.

If I put this on a dashboard and add a filter, it only gets worse. Now it should show last 6 months, but it's showing 6 weeks from the beginning, and 4 "random" weeks in the middle, but no data from the last 3 weeks for example (where I definitely have data).

Could someone help me figure out what's going on here? What am I missing?

I really appreciate the help; thank you already in advance.

Cheers,

--Mikko

[mikkojuola · Accepted solution]

In case anyone else is experiencing the same problem, I got a solution from the support:

PRB1649679. This is fixed in Data visualization Bundle to V.2.0
OR as a workaround, you may follow the below steps
- change the chart type to donut/pie
- click on the group by field and set "Max number of groups" to "Show all"
- then switch back to the previous timeseries chart type
- set the values of trend by and groupby as before
The chart will show the whole time range with or without group by.

And I can verify both solutions. The problem is gone with Vancouver, and the workaround also worked in Utah.

Cheers,

--Mikko