An interval of data is missing from some visuals

[SimonNagy]

Hello All,

I am facing a pretty strange issue, where some of my visuals are displaying all data, and some of them are not.

• In some visuals, I can only display data from the end of November 2023,
• in some visuals, all data is displayed from July 2023,
• in some visuals some data is displayed in July 2023, and then a blank interval, and then all data after November 2023.

I have no active filters (double checked), there is data in the database, and also I am using the same attributes. Have you encountered anything similar before?

Thanks in advance,

Simon

[SimonNagy]

Just a slight update: if in the transform data platform, I filter rows so only records in the "empty" time frame should be loaded, the affected visuals are empty...

The filter on the visual look like this, so I think this should not be an issue (especially considering it works on other pages).

[Idrissshatila]

@SimonNagy ,

and the measures displayed in all the visuals is the same measure ?

[SimonNagy]

@Idrissshatila You are right; i've found a rogue filter in one of the visuals. After that I've removed filter sync, and deleted the general date filter. And then a new filter appeared, which was something from earlier 😀

I'll move through the whole report, and re-sync the date filters, as that is the root of the issue. Thanks for your time, and the help!

Best regards,

Simon

[Idrissshatila · Accepted solution]

HEllo @SimonNagy ,

how did you check that there's no active filters, have you checked the filter pane for each visuals (filter on visual) ?

[SimonNagy]

Hi @Idrissshatila ,

yes, I've checked the visuals, and the pages as well, they all have the same setting of Date (All).

[Idrissshatila]

@SimonNagy ,

havr you tried creating the visual again and got same result ?

[SimonNagy]

I've just tried that, and got the same result of some dates not appearing. 

I am using import mode, because I have to make several measures/transforms, and I have 16 pages so far. Can this be a limitation of that? That is the only thing I can think about now.

I have like 51,000 rows of data in 3 tables (~ 15,000 ++ 1,000 ++ 35,000) with 10-15 attributes per table (I think it's not that many)