Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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:
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