I have a requirement. There are addresses and prices in the task table. I want to make a report and dashboard. I want to display the prices according to different locations and put them in the dashboard. There are more than 10 locations. Should I create a report for each location and put it in the dashboard? Or is there another way?
To understand better, in the Task table, you have:
Address
Price
If you want to display data based on location, you will need to create separate reports. Additionally, the type of report is also important to consider.
I think we need to understand some further about the data structure if you ask about what you should create. So for me to understand.... How many addresses do you have? Does each location have one or multiple prices? What is it that you would like to obtain from the visualization?
Thanks for your answer. I have 20 addresses, but there may be several amounts in one region and I want to sum them up. Also, I want to find the corresponding report in the dashboard by region name. I created an Interactive Filter of Referencetype but it still doesn't work.
To understand better, in the Task table, you have:
Address
Price
If you want to display data based on location, you will need to create separate reports. Additionally, the type of report is also important to consider.
@kack l You can create report with interactive filter. You only need to create one report only and based on interactive filter, your report will be updated accordingly.
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
