FormulaWidget issue with mode global disabled about carto-react

[AdriSolid]

From my side using that tileset it's okey

[padawannn]

@menusal can you create a map in builder and share it (with password if you want)? It sounds like a problem with data

[menusal]

@padawannn https://gcp-us-east1.app.carto.com/map/366acf70-ecff-4544-8cba-0d198a8c9100

[padawannn]

Checking the map I can say that the widget doesn't show data because of dropping features. @VictorVelarde we should fix the infinite loading on C4R side.

[alasarr]

It'll be fixed with this https://github.com/CartoDB/cloud-native/pull/8919 where we're removing the aggregation of points.

The current behavior for layers using dynamic tiles is that if two points have the same coordinates will always be aggregated so the widget says that you should zoom in because some data is missing in the calculation.

Dynamic tiling is used for tables larger than 30MB or queries. So that's why it also happens with a limit 1000.

Using your query you can see how you already have duplicated points:

select st_x(geom), st_y(geom), count(*) as n from carto-dw-ac-glcwr7d.shared.usa_pos
group by st_x(geom), st_y(geom)
order by n desc

Of course it's wrong and will be fixed with this https://github.com/CartoDB/cloud-native/pull/8919. Can you try to use that dedicated and verify it's solved there? I would like to deploy it today or tomorrow.

cc: @moimart

[aaranadev]

@alasarr, we don't have enough knowledge to test with a dedicated server, we need support.

So if you've tried it, merge it when you can.

[padawannn]

@alasarr, we don't have enough knowledge to test with a dedicated server, we need support.

So if you've tried it, merge it when you can.

@aaranadev if you open the PR that @alasarr comment (https://github.com/CartoDB/cloud-native/pull/8919) you will see in the comments something like this:

https://app-12.dev.carto.com/ is the link of the dedicated, you only need to sing up in this dedicated with your carto account and you will have access to the cloud-native version deployed in this dedicated

[aaranadev]

Ohh great! Thank you @padawannn

[AdriSolid]

Hey guys we've been trying to create a simple FormulaWidget from a tileset (carto-dw-ac-g1ktp5ij.shared.acs_sociodemogr_de06bf47) in located in https://app-12.dev.carto.com/ ded with no luck. Please @padawannn @alasarr could you take a look? I'm not sure what's happening:

<FormulaWidget
  id='total-population-widget'
  title='Total population'
  dataSource={DEMOGRAPHICS_SOURCE_ID}
  column='total_pop'
  operation={AggregationTypes.COUNT}
/>

cc @aaranadev @menusal

[padawannn]

Hey guys we've been trying to create a simple FormulaWidget from a tileset (carto-dw-ac-g1ktp5ij.shared.acs_sociodemogr_de06bf47) in located in https://app-12.dev.carto.com/ ded with no luck. Please @padawannn @alasarr could you take a look? I'm not sure what's happening:

<FormulaWidget
  id='total-population-widget'
  title='Total population'
  dataSource={DEMOGRAPHICS_SOURCE_ID}
  column='total_pop'
  operation={AggregationTypes.COUNT}
/>

cc @aaranadev @menusal

@AdriSolid can you publish the map and send us the link? If data are private you can publish it under a password

[AdriSolid]

Sorry for the noise guys, we just found the problem, if using onDataLoad prop we must call that method from useCartoLayerProps response, i.e:

onDataLoad: (data: TileJson) => {
  const targetAttribute = data.tilestats.layers[0].attributes.find(
    (attribute: TileJsonAttribute) => {
      return attribute.attribute === STYLE_PROP
    },
  )
  targetAttribute && setTilestat(targetAttribute)

  cartoLayerProps?.onDataLoad?.(data) // NOTICE THIS
},

cc @aaranadev @menusal

[padawannn]

Sorry for the noise guys, we just found the problem, if using onDataLoad prop we must call that method from useCartoLayerProps response, i.e:

onDataLoad: (data: TileJson) => {
  const targetAttribute = data.tilestats.layers[0].attributes.find(
    (attribute: TileJsonAttribute) => {
      return attribute.attribute === STYLE_PROP
    },
  )
  targetAttribute && setTilestat(targetAttribute)

  cartoLayerProps?.onDataLoad?.(data) // NOTICE THIS
},

cc @aaranadev @menusal

So I understand that everything works with the dedicated, right?

[VictorVelarde]

Please confirm, so we can close the issue once ded code lands prod

[menusal]

From my side using table source with the dedicated, it's ok.