Forum Discussion

Rajsheisan's avatar
Rajsheisan
Frequent Visitor
4 years ago

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.

 

Thanks in advance.

 

4 Replies

  • Rajsheisan's avatar
    Rajsheisan
    Frequent Visitor

    Hi Ibendlin,

    Thanks for the response.

    group_nameDategroup detailsMonth_TargetCurrent_MonthFYTDLYFYTD
    A2022-06-18A-1100%100.00%93.18%91.69%
    A2022-06-29A-1100%90.00%93.18%91.96%
    A2022-06-18A-180%100.00%93.18%91.69%
    A2022-06-29A-180%85.00%93.18%91.96%
    A2022-06-18A-185%100.00%93.18%91.69%
    A2022-06-29A-185%100.00%93.18%91.96%
    A2022-06-18A-190%100.00%93.18%91.69%
    A2022-06-29A-190%100.00%93.18%91.96%
    A2022-06-18A-195%80.00%93.18%91.69%
    B2022-06-29B-195%90.00%93.18%91.96%
    C2022-06-12C-1100%75.00%57.75%61.47%
    C2022-06-16C-1100%60.00%57.75%61.40%
    C2022-06-25C-1100%90.00%57.75%61.52%
    C2022-06-12C-180%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.

    • lbendlin's avatar
      lbendlin
      Super User

      What happens when you plot your data with the standard line visual?

      • Rajsheisan's avatar
        Rajsheisan
        Frequent Visitor

        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.