Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with dimensions only, no measures. Also I have a filter pane. Depending on options from the filter pane I'm showing data in the table. For example, in filter pane I have degrees . Depending on the selected degree I show corresponding specialties in my table. But if no options are selected in the filter pane I'm getting error message "incomplete visualization". Ideally, I'd like to have by default empty table with column headers(labels) but without data. When end user chooses options in filter pane, information will appear in the table. If it's not possible, I'd be happy to have at least white screen with filter pane(no error message) and let users select options in filter pane. Please help!
P.S. Perhaps I'm doing it wrong way and should use buttons of something else? I'm open to different options.
Thanks a lot in advance!
That's my formula
=if(GetselectedCount(Degree)>0,1,0)
Where can I put user message?
Perhaps I'm in the wrong menu...but I don't have this field. Where Can I find it?
Thank you! I found this field! If I put in the message field 123, I'm getting 123 instead of error message. But if I'm entering =' ' or =(' ') I'm getting an error message instead of empty field. What should I enter to avoid getting any messages? If it's possible?
May be this -
=chr(32)
Thank you so much!!!! It is working!
Hi Digvijay_Singh,
sorry for bothering you again with the same issue.
For some reason the same formula now "if calculation condition =1" still show error messages on the screen.
If I put "calculation condition =0", then I don't see error messages but I also don't see columns that I'm choosing in my filter. What's the rule? What should I put in the calculation condition to avoid error message on the screen when nothing is selected?
Thanks a lot in advance!!!
should be =if(GetSelectedCount(field),1,0) in calculation condition
Hi,
Calculation condition if results into 0 should show the error message, to suppress the error message we used =chr(32) in the error message.
Calculation condition = 1 should show you the table, indirectly it means you made selections in the filters so you should be checking getselectedcount(fieldname)>1, that should result into 1 if you made selection in the field of your filter pane.
But you won't see anything when your calculation condition is 0 because the whole chart is not calculated at all.
Thanks,