Forum Discussion

sperry's avatar
sperry
Icon for Resolver I rankResolver I
4 years ago
Solved

Cumulative Values Not Showing Correctly On Date Axis

I would like to present a graph that shows the cumulative number of booster vaccinations required by month. created a 'dummy' model containing the scenario. Please see model in link below. I seem to ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi sperry ,

    Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.

    Note: The part with red font is updated one...

    Total Cumulative Boosters Required Maori =
    IF (
    ISBLANK ( [Total Cumulative Eligible Booster Māori] )
    || ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),
    BLANK (),
    ( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] )
    )

    Best Regards

  • sperry's avatar
    sperry
    4 years ago

    Perfect - works a treat..thanks for that

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Your data has blank "Eligible Booster Date"  fields.

  • sperry's avatar
    sperry
    Icon for Resolver I rankResolver I
    4 years ago

    You are absolutely right - I use the data for several reasons so some rows are validly blank for the "Eligible Booster Date"  fields. Not sure how this helps me. If I filter out the blank dates then incorrect values are shown in the column chart visual

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi sperry ,

      Please try to update the formula of measure [Total Cumulative Boosters Required Maori] as below and check whether it can get your expected result. You can find the details in the attachment.

      Note: The part with red font is updated one...

      Total Cumulative Boosters Required Maori =
      IF (
      ISBLANK ( [Total Cumulative Eligible Booster Māori] )
      || ISBLANK ( [Total Cumulative Boosters Administered DHB Residence Māori] ),
      BLANK (),
      ( 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Eligible Booster Māori] - 'COVID-19 Vaccinations DHB of Residence'[Total Cumulative Boosters Administered DHB Residence Māori] )
      )

      Best Regards

      • sperry's avatar
        sperry
        Icon for Resolver I rankResolver I
        4 years ago

        Perfect - works a treat..thanks for that