Forum Discussion

somogyitamas88's avatar
somogyitamas88
Regular Visitor
6 months ago
Solved

Dynamic Y range visual calculation in two level hierarchy

Hi! I have a column chart. To the rows I put two level of dates: YearMonth and YearWeek To the values I put Sales, Sales plan. I would like to make a visual calculation solution for the Y...
  • Anonymous's avatar
    Anonymous
    5 months ago

    Hi somogyitamas88 ,

     

    Could you kindly provide a small sample of your data, ensuring that it contains only the date, Sales, and Sales Plan fields, with no sensitive information included.

    Additionally, please specify the Y axis values you would like to see at both the month and week levels so I can accurately align the solution to your requirements.

    Thank you.

fla_mota's avatar
fla_mota
Frequent Visitor
6 months ago

One way to handle this is to use ISINSCOPE to check whether the visual is at the YearMonth or YearWeek level. From there, you can calculate the highest value between Sales and Sales Plan at that level. This way the Y-axis maximum adjusts automatically when you drill in the chart.