IF file is to heavy ----> display a message

[Uri]

Hi!

I want to display a message "The file you are trying to export is to large. It can take a few minutes to export it - reduce number of days and try again". IF my file is more than 6 mb or has more than 200 000 ROWS ---> SHOW A MESSAGE. I'm using table as a chart.

Is there is any way to do this?

BR,

Artur

[ArnadoSandoval · Accepted solution]

Hi @Uri 

These are some ideas:

The expression below returns the number of selected records, you can check its run-time value against you limit and display a message on the sheet, by the table's footnote, text box, KPI; replace Dimension with the name of the main dimension in your table.

Count(total [Dimension]) 

 You may add a message like the ones shown below:

[Uri]

Good point @ArnadoSandoval ! It helped to fix my issue.

I used GetSelectedCounts on a date field. IF dateField has more than 60 days selected - display a message "Too many records selected - reduce number of days". I used show condition as well i.e. if more than 60 days selected - display a message else hide it. So it looks good now 🙂 Thanks for your reply!

BR,

Artur