Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Export to csv shown wrong total.

Hi all,  When i export my visual data into csv file the total of value column showing me wrong i had created measure = Distinctcount(Homenumber) I was trying to convert visual into table and find o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

It's better to share some sample data if you don't have any Confidential Information.

I did some simple test but could not reproduce the scenario.

 

Best Regards,

Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous here is the sample data.

DateE_IDRegionHome numberStatus
6/21/2021650North6RH
6/21/20213East6RH
6/21/20211West6RH
6/21/2021650North14RH
6/21/20212South14RH
6/21/20211West14RH
6/21/2021650North20RH
6/21/20212South20RH
6/21/20211West20RH
6/21/2021650North35RH
6/21/20212South35RH
6/21/20211West35RH
6/21/2021650North38RH
6/21/20212South38RH
6/21/20211West38RH
6/21/2021650North39RH
6/21/20212South39RH
6/21/20211West39RH
6/21/2021650North46RH
6/21/20212South46RH
6/21/20211West46RH
6/21/2021650North49RH
6/21/20212South49RH
6/21/20211West49RH
6/21/2021650North53RH
6/21/20212South53RH
6/21/20211West53RH
6/21/2021650North60RH
6/21/20212South60RH
6/21/20211West60RH

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    I didn't get the point. Shouldn't the total result be 10? Do you want it to be 30?

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous i know it should be 30 because each row of table has group of same values and unique_HH is distinct count of this particular group but if you can see on line chart the total of 10 by date and the client requirment is  should be 10 on export not 30..
      I know client requirment may be wrong becasue line chart shown distint count on date wise only and table shown distinct count based on group of values.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        The total of a measure is a calculated value returned by the formula. It's not a simple cumulative value of the measure.

         

        Best Regards,

        Jay