Data Issue. How to identify the missed group.

[#1]

Hi

I have a Straight table where it shows the opened Ticket Numbers for every month. for example July-159, Aug-53 as last week total nos. but today it's showing less data for both the months. Please someone could look into this and throw some insights. Expression for the measure in St table. as below and data is loading from 2 different groups. How to find out which group data is missing?

if(isNull(sum(IncidentsOpened)),0, sum(IncidentsOpened))

Regards

Velan

[#2]

Hi Velan,

Please explain how are you loading data from QVD or any other method..

what is the frequency of data refresh.

it seems if you have not changed expression then because of any of the source incoming data has been changed.

[#3]

Hi Pooja,

Am loading data from QVD directly and refresh is triggered fortnightly. We're using the same expression and there is no change in source comes in.

Thanks

Regards

Velan