4.02-09 Publish charts with full filters initially

If the chart has a filtered axis, set the filter such that all items are shown, then publish the chart.  Then set the filter criteria back as desired; the chart will then respect the filter

Tagged:

Comments

  • Rule 4.02-09 Publish charts will full filters initiallyIf the chart has a filtered axis, set the filter such that all items are shown, then publish the chart.  Then set the filter criteria back as desired; the chart will then respect the filter

    Use Case:  Based on the selected month which an end user will select on the dashboard end users want to see the same month of the prior year and of the future year in a graphical representation so that he can compare his current month numbers with PY Actuals and can also see the Forecast

     Here is how it was done in Pre Planual Era: We used to create a saved view with filters applied based on the logic. And then publish the chart based on the saved view of the grid

    Misbah_1-1594380401610.png

    What is wrong with this method? It will be not be dynamically updated when end users change the selection from the current month to any other month on the dashboard. Instead end users will be greeted with the error message (Screenshot below)

    Misbah_2-1594380414340.png

    That is because charts have been published from the saved view which displayed selection with respect to Jan 20 selection

    Here is how it should be done in Planual Way: The filter that you have applied on the saved view needs to be changed to so that all months of the timescale are shown, publish the chart, come back to the filter and apply the logic back in to the line item

    Step 1:  Go to Filter Line item and Set it as TRUE

    Step 2:  Publish the chart based on the the newly filtered line item, which shows all the months. Your chart may look like this

    Misbah_3-1594380446878.png

    Step3: Go back to the filter line item (which is applied on the saved view) and apply the logic as per the requirement

    Step 4: Refresh the dashboard

    Misbah_4-1594380459739.png