Calculation Time Out Error for Bar Chart

[Heena]

Hi All,

I have below records: 

B_ID Count: 10000

ST_ID Count:19,00,000

LG_ID Count: 60,000

In script in am using:

Autonumber(B_ID&ST_ID&LG_ID) as New_ID.

In Bar chart expression used is:

Count({<C_status ={1}>}distinct  NEW_ID)

Bar Chart is loading very slow and after 2 mins its giving Calculation Time Out Error.

In server we cannot increase the standard time set from 120 s.

Help needed here, Please advice me on this.Thanks in Advance!!

Regards,

Heena Kauser

[sunny_talwar]

How big is the dashboard in size? I am asking this because is it possible that you have a many to many join which might be making this a huge application which would slow everything on the front end

[Heena]

Hi Sunny,

Yes, the file size is huge and the application is having historical dates and data as well.

File Size: 3033 MB

Thanks & Regards,

Heena Kauser

[Deesha]

Hi Heena, Could you please share the resolution? As I facing the similar issue.

[XzavierMurray]

Hey, i have same issue and still waiting for the answer can anybody suggest what should i do?

Myloweslife

[Noa]

Hi Heena, 

I wonder if you mind sharing the solution for that problem.