Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have Dashboard, suppose i have a BAR char, customer wise data,
when i am click any particular Customer bar i want show details report in Straight table or pivot table...
please give me suggestions, how present data.....
Create the straight table. When you click on a bar in the bar chart the straight table will be filtered automatically too. If you don't want to show the straight table if no customer is selected then enable the option Conditional on the Layout tab of the properties window and enter an expression =getselectedcount(CustomerIDFieldHere). Replace CustomerIDFieldHere with the name of your customer field.
Create a Straight Table or Pivot Table as per your requirements and go to Layout tab
Conditional Show
GetSelectedCount(Customer)>0
Now this table will only visible one you have at least one customer selected... How this help.
You can either set up your straight table (as a separate object, not in a container_box) with a visibility_condition and place it in the same position as your bar_chart and set the barchart with the opposite visibility_condition so when someone clicks on a bar (which you can find out with GETFIELDSELECTIONS()) the barchart will disappear and the details_table will appear - in that case, don't forget to implement sth. like a "Back" button to revert it ...
Best regards,
DataNibbler
Hi,
I have done something, please check once..
i have BAR chart when i am click any bar i need to display detail report...
i have created one variable(vShow) and Close button,
when i am click close button i need to close Detail report.....
See attached qvw