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

[jeffrubinoff]

What version are you on?

[mikkojuola]

Our app development instance is on Utah release.

[AndersBGS]

Hi @mikkojuola ,

I guess that you're utilizing analytics workspace - right? 

If yes, then I would recommend to create a HI case with ServiceNow, as I have seen several visualization issues with Analytics workspace. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[mikkojuola]

Thanks Anders.

I reported this issue via Support portal just now.

--Mikko