Forum Discussion
Create charts based on selected measure and fields
Hi, I am trying to create charts (it could be a bar or line chart) in just one bucket based on a selected measure and field/s values from a table. Would any one healp me on this please. Thank...
Hi Ibendlin,
Thanks for the response.
| group_name | Date | group details | Month_Target | Current_Month | FYTD | LYFYTD |
| A | 2022-06-18 | A-1 | 100% | 100.00% | 93.18% | 91.69% |
| A | 2022-06-29 | A-1 | 100% | 90.00% | 93.18% | 91.96% |
| A | 2022-06-18 | A-1 | 80% | 100.00% | 93.18% | 91.69% |
| A | 2022-06-29 | A-1 | 80% | 85.00% | 93.18% | 91.96% |
| A | 2022-06-18 | A-1 | 85% | 100.00% | 93.18% | 91.69% |
| A | 2022-06-29 | A-1 | 85% | 100.00% | 93.18% | 91.96% |
| A | 2022-06-18 | A-1 | 90% | 100.00% | 93.18% | 91.69% |
| A | 2022-06-29 | A-1 | 90% | 100.00% | 93.18% | 91.96% |
| A | 2022-06-18 | A-1 | 95% | 80.00% | 93.18% | 91.69% |
| B | 2022-06-29 | B-1 | 95% | 90.00% | 93.18% | 91.96% |
| C | 2022-06-12 | C-1 | 100% | 75.00% | 57.75% | 61.47% |
| C | 2022-06-16 | C-1 | 100% | 60.00% | 57.75% | 61.40% |
| C | 2022-06-25 | C-1 | 100% | 90.00% | 57.75% | 61.52% |
| C | 2022-06-12 | C-1 | 80% | 90.00% | 57.75% | 61.47% |
for th eabove table, when someone clicked on any of the row the selected Month_Target and Current month data should be shown in a chart for the particular date as well as drill thru data for a given month. I have a calendar table with all required details.
The output of the chart should show Month_Target against Current month values for a particular date and the month selected. The ch
Thanks for your help.
What happens when you plot your data with the standard line visual?
Thanks again,
I managed to get the line chart as shown above using month_target and current_month (actually it is day) averages but, still a bit confused as I suspect the day values are shown per each group is lesser.