Dashboard to display month data

[Former Member]

Hi All,

I have a requirement to show data for all the days of a particular month. As per requirement user needs chart like below

Here if user clicks on any month(Bar in chart) in below chart it has to display that particular month data.

In above chart MAY month has selected below chart displayed MAY data

Please suggest how to achieve this?

Regards,

Saroja

[saurabh_sonawane]

Can I direly use Bex query for this

yes you can use a direct bex query to dashboard

query 1 contain = calmonth and other measure

Note(if u can filter the bex query for 12 month is wel and good)

query 2 contain = calday and other measure

and with prompt as month in query 2.

make sure you apply filter in bex query to get only last 5 year data as showen in your dashboard

and cal month should be sorted in dec,

[Former Member]

Hi Saurabh,

Sorry for the late reply.

I have followed your suggestion/steps, encountered with few issues.

1) Firstly I tried with some sample data below is the screen shot

1.1)Output which got

Here when I press cat2/cat3 corresponding chart is getting change.

Here the issue is for Cat1 nothing is displaying.

I followed same steps to build dashboard according to my requirement, encountered with issues.

Please check below screen shots for more clarity

2.1)Mapping to a column chart. Here there are 2 columns Illness and Incidents, my doubt is how to map cell(yellow/Green) to a combo box.In above screen shots(1)there is only one cell(yellow) binded.But here there are 2 highlighted cells, how to map this to combo box?

2.2) Mapping of another column chart having detailed data

2.3) Output of the chart

Here if I press Jan(bar) Illness is displaying in List View and Feb(bar) displays Incidents, if I press Mar nothing is displaying. Also main issue is chart is not changing accordingly and nothing is visible in combo box.

Please help in achieving desired output.

Regards,

Saroja

[saurabh_sonawane]

Hi

The untitled1 is used to tell the mapping with the Column Line Chart

and

untitled tell you the mapping of inseration in the Column Line Chart

[former_member182541]

Can you check with the below link, which is pretty much same as your requirement. Can you send me a test to my id so that i can share the source xlf.

[Former Member]

Hi Saurabh,

Thanks for your response and solution.

I achieved it partially but for month of Jan it is not working, for remaining months Feb & Mar data is displaying in Combo box & List view and corresponding chart is changing.

Please look into below screen shots for more clarity

1) Combo box mapping

2) Combo box Behaviour tab

3)My output

4) Screenshot of JAN

JAN month is not populating in Combo box and in turn chart is not displaying the corresponding data.

Please suggest me how to get JAN data as well.

Regards,

Saroja

[saurabh_sonawane]

Hi,

Great only little change and it will work fine

just we have to change the mapping of destination field of combobox

Note

we cant overwrite the destination with the source data plz map the combobox destination on sheet1!$k$3:$n$5

and map this output to the next column line chart

plz find an

[former_member182541]

Check with the attached text file, change the extension from txt to xlf (or) drag and drop this file into the dashboard. Hope this clarifies.

DRILL DOWN.txt.zip

[Former Member]

Hi Suman,

Thanks..

I will check file keeping in dashboard.

Regards,

Saroja

[saurabh_sonawane]

Hi,

just create a two query

query 1. content the month wise data to display.

query 2 content the calendar wise data

and make sure u pass the month back to the query 2 as a prompt

and use a drill down funcation of chart which is present in the behaviour tab of chart

[Former Member]

Hi Saurabh,

Thanks for reply..

Can you please explain me in detail about few points like

1) Can I direly use Bex query for this or Do i need to create a webi report and LO to get this to dashboards.

2) If you say webi on top of dashboards then to which component I need to map prompt values

I cannot see drill down function in Behaviour tab.What to do to make it visible.

Regards,

Saroja