Need help to identify missed time interval has to represent in text box

[Anonymous]

Hi All,

Need help to identify which are time intervals has missed the data. Sample application is attached.

stalwar1‌

[juraj_misina]

Hi,

those intervals are not in your data. You need to generate those intervals (inline, in excel or in script), join that onto your fact table and then you can use:

=Concat({<Half_hr_bucket={"=Sum(Calls_Count)=0"}>} Half_hr_bucket, ', ')

in your text box.

Hope this helps.

Juraj

[fvelascog72]

Hi,

Hope attached file helps.

Saludos.

[Anonymous]

Hi Velasco,

Can you recreate the same application with out loading the data using Inline loader.

Thanks & Regards,

Venkata Sreekanth

[fvelascog72]

Hi,

If you need to load data from excel you can send me the files and try to do it.

Saludos.